Forum Discussion
Adding non filtered graph to drill through page
Hi all.
I have a drill through page 2 navigated from a std bar chart Page 1
Page 1 Chart is Area (Y) and Downtime (X), filtered in slicer by Week number.(N)
When I drill through, I get a graph of Machine (Y) Downtime (X) by Week(s) on page 2 for a selected area on page 1
I now wish to add a new line graph that shows the filtered Machine, but defaults to ALL Weeks (non filtered Week No.)
This new graph is to be used as a visual comparison of my machine downtime for the year against the original graph of area downtime for the selected week(s).
Is this an option, or would the new graph need to be on its own seperate page ?
Thanks in advance.
Hi POSULL24 ,
Here I suggest you to duplicate the bar chart in Page1 which has "None" interaction with the Week Number slicer.
For reference:
Change how visuals interact in a report - Power BI | Microsoft Learn
Then you can drill through from this visual to get the all week data in Page 2.
Setting in Drill through in Page 2.
Result is as below. In Page 1, left one is the normal bar chart and right one is the visual remove filter from slicer.
Drill through from left one.
Drill through from right one.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi POSULL24 ,
Here I suggest you to duplicate the bar chart in Page1 which has "None" interaction with the Week Number slicer.
For reference:
Change how visuals interact in a report - Power BI | Microsoft Learn
Then you can drill through from this visual to get the all week data in Page 2.
Setting in Drill through in Page 2.
Result is as below. In Page 1, left one is the normal bar chart and right one is the visual remove filter from slicer.
Drill through from left one.
Drill through from right one.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.