Forum Discussion
Repost: dynamic legend on Power BI using DAX
Hello there community!
Hope you're doing all right
Few days ago, I posted this question: https://community.fabric.microsoft.com/t5/Desktop/Ways-to-make-a-legend-dynamic-by-using-DAX/m-p/3683060 which was techically solved, it worked like magic! However, it introduced few concerns with the modelling and I'd like to know if there's another way to achieve the same results, but with a constraint:
- not duplicating dim tables
if it's a measure that I can apply to the visual, better.... but duplicating the same table unfortunately won't work for me 'cause it doesn't match well with the currently modelling. It's a shame, 'cause I really liked the solution.
Any ideas? =]
Thanks in advance! 🙂
talitanieps , If you select a value and want more than those values to be used on Axis/Legend and row/column etc.
You need an independent table in the slicer, which means you need to have a duplicate table
All these cases have a similar need
Need of an Independent/disconnected Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE
Need of an Independent/disconnected Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg
Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: https://youtu.be/exN4nTewgbc
1 Reply
- amitchandakSuper User
talitanieps , If you select a value and want more than those values to be used on Axis/Legend and row/column etc.
You need an independent table in the slicer, which means you need to have a duplicate table
All these cases have a similar need
Need of an Independent/disconnected Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE
Need of an Independent/disconnected Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg
Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: https://youtu.be/exN4nTewgbc