Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I am trying to replicate a functiion I had in tableau where I could select one item on different visualisations to drill in to the data.
eg selecting a Contact Reason filters the URL list and clicking on the URL list filtered the view to only those on both the Reason code and the URL.
When i chose the Contact reason this works and when I CTRL click on the URL it just refilters on the URL.
Any thoughts
Aaron
Solved! Go to Solution.
Hi @Aaron,
Please create a relationship between the visual by clicking Edit interactions under format on home page. Please select the button highlighted in red line, then it will be effected by other visual.
Best Regards,
Angelia
Hi @Aaron,
Please select the URL column-> Data categories->Web URL. You can click it, it will jump to corresponding source.
Create a table visual to verify the result. Please see the screenshot below.
If this is not want you want, please share more details or sample data table for further analysis.
Best Regards,
Angelia
Thanks for the quick response.
The below may better explain what I am trying to do. What I want to do is highlight the reason code on the bubble chart and then the url on the bar chart and then see the other charts on the page just show the data that is both for reason code 12 and URL 17.
Hope this makes sense
Aaron
Hi @Aaron,
Please create a relationship between the visual by clicking Edit interactions under format on home page. Please select the button highlighted in red line, then it will be effected by other visual.
Best Regards,
Angelia
Thanks for the response. I have tried this and do get the first chart to highlight but then cannot select an item on that chart to filter the rest of the visualisations as it resets the other view.
Guess thsi may just not be possible.
Aaron
For anyone in the future, what OP is describing IS possible with a ctrl+click. Unfortunately this feature is not obvious.
Documentation: https://docs.microsoft.com/en-us/power-bi/desktop-multi-select
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |