Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Though this request is a related one with my previous post, im trying to create a new one because this itself pose as a new requirement
i have this line chart with Years in Legend. I would like a funcationality, when a user click on a year in the legend, it should pop up a matrix table with that year filtered in it. I already have created this matrix table.
Any idea how can i add this functionality into legend?
Hi @LP2803
Would you like to try the bookmark? You might need to add additional button instead of clicking the legend directly.
Based on bookmark, you can achieve it once the related year selected, the chart will be filtered as well as pop up a new matrix table.
Please refer to the official document for mroe hints:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks
@LP2803 - So, you could create a flag based upon HASONEVALUE('Table'[Year]) and maybe do something with that, like use it as a filter on your matrix visualization.
Hi Greg, Thanks for looking into it.
I have other visuals below my line chart. So when I click on a year in legend the matrix chart shoudl overlay on the other visuals that i have below the line chart.
Any idea around this?
@LP2803 - Well what I was thinking is that based on the flag the matrix would return completely empty or not. One other thing, although it is an extra step. Would be to create some bookmarks that did the show/hide of visuals and make the user click the button after selecting a year.
Not sure there is a perfect solution here for what you are asking.
@amitchandak Thanks Amit. would you suggest any particular custom visual for my requirement?
Team,
I still have this as my open topic. if anyone has any thought, kindly share.
Thanks Greg for the idea. Could you please elaborate how can i make the matrix go empty when there is no selection in the legend?
@LP2803 , I doubt such functionality. Check custom visual
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
I would like to iterate that the matrix table that i have is already being filtering based on the legend selection.
But i would like to make it as a pop up only when user selects a year in legend.
Is this possible?
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |