Good morning all,
Besides “drill through” to carry “filtered data” from a visual to the next page, if there is a way DAX query can achieve the similar function ? --> passing selected bar chart info to the next page (diff reporting tabs, but inside the same PBIX file)
1)Power BI can sync “filters” between reports. (we are using it)
2)Drilling through in power BI --> in some of our use cases, not perfect.
E.g. during right clicking, too many other options besides “drill through” . (I have posted this question as a separate topic)
When user selected a bar chart, then continue to click on “View Detail” button, not only the “theDate” & “PvsN” filters will sync to the detail page. But also the data selected on bar chart. (in my example below: Jan 1 2019 data)
here is the PBIX sample file.
Selected bar chart to next page.pbix (239.5 KB)