Forum Discussion
One date slicer from several queries/fields
Hello, I have a Power BI report with three visuals that I'd like to apply one date slicer to. The three visuals are populated by three separate fields/queries and each of these have a date colu...
In Power Query, create a new date "Fact Table" from the three original tables, which contains only date (deduped).
Go back to Desktop, Model View, and set up relationships between the Fact Table and each of the three other tables.
Create a date slicer using the new Fact Table.
Providing the interactions are correct on your report tile, selecting a date from the new slicer should update everything else.
AndrewPF
Helper V
Helper VI think they can have different names.
Thanks, yes I'm just starting now and seems to let me link them regardless of title.