Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In this matrix, the columns "5cm" and "14cm" are measures. I would like a mobile user (who I will share the report with) to be able to choose which measure they see, so if they choose "5cm" the visual then only shows that column and hides the "14cm" column. I know you can't use measures in a slicer so I'm not sure how else I can achieve this.
So basically, what I'd like them to be able to see is this:
Solved! Go to Solution.
A typical way of handling this is with a "measure selector" measure.
Selected Measure = SWITCH ( SELECTEDVALUE ( 'Measure Selector'[Measure] ), "5cm",[5cm], "14cm",[14cm] )
Here's a very small example pbix.
Regards,
Owen
A typical way of handling this is with a "measure selector" measure.
Selected Measure = SWITCH ( SELECTEDVALUE ( 'Measure Selector'[Measure] ), "5cm",[5cm], "14cm",[14cm] )
Here's a very small example pbix.
Regards,
Owen
Hi Owen,
I found your comment and did some emendments and works.
However my issue is that when I slect a brand from a slicer all data is showing, I would like to see only the data for the slected slicer.
Any idea how to go around?
Thanks,
Stephen
That worked and so simple, thanks for the example that was really helpful to use.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |