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.
Hi,
I'd like to hear your considerations about how I solved this specific problem.
I have a matrix that has (let's say):
as columns:
as values:
as rows:
I have been asked to have the possibility to remove the "Sales quantity" or the "Area".
My solution has been the creation of four button images that are linked to a bookmark that shows these matrix:
It's not quite nice to see, and everytime I press one of these buttons the visual objects are resetted.
I was wondering, is there another way to achieve my scope?
I know there is the possibility to use the SWITCH function to switch a measure, but I guess this is not the case for this to be used, am I right?
I underline that is important that the row dimensions mantain the order I specified: Client, Area, Item.
Many thanks to anyone who may help me.
Hi @MaxItaly,
I have made a test with creating 4 buttons and bookmarks try to get your requirement.
You could Ctrl+click the button, and it will show the corresponding visual.
More details, you could refer to my test pbix file.
For further, you could refer to this video.
Best regards,
Cherry
Thanks for your reply and the time you spent for answering me,
maybe I've not been quite clear, but that's the kind of solution that I've already implemented.
What I really wanted to ask is if there is another way to achieve this, because the final users don't like this kind of solution.
I am quite sure this is the only one possible way, I just wanted to be sure by asking this to users who have more experience than me.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |