CODEWITHSUNDEEP
powerbipowerbi-desktop
saidesh
saidesh

Reputation: 3

power bi: how to add common date slicer that filters on two or three charts data based on date

How to add common date slicer which will filter two or three charts data based on date column of those charts

i have tried to create a date table and applied relation and when i used date slicer it is showing empty data even though data is there in the mentioned dates range

I need to create a common date filter for three charts present in power bi report. three charts using three different tables and with different columns we dont have any relation between them. But all three tables have a date column so Now i need to create a common date slicer so that i can filter using that and results should be generated

slicer should filter data of multiple charts.

Upvotes: 0

Views: 3950

Answers (1)

sqlarcher
sqlarcher

Reputation: 101

The best suggestion is to build your own date table in Power BI. You can take a look at this post here for more details.

Now you might end up having to normalize the dates in your existing tables as well to ensure that you are linking all tables on a common date type.

Upvotes: 0

Related Questions