Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello Community - Modifying my original post to better explain what I am trying to do.
Creating a field measure with these 4 options is easy and of course you end up with a slicer that has these 4 options. However, I only want to show two of them because what I actually want is when the user selects Quantity...the matrix visual should show Quantity and % of Qty. If they select Revenue, then the matrix should only show Revenue and % of Rev. I don't want to show all 4 options.
Perhaps I am going about this the wrong way, but I was hoping I could utilize field parameters to essentially mimic the behavior of adding the Revenue measure twice..and then having the 2nd one be the "show as % of column" option.
Solved! Go to Solution.
Hi @Anonymous ,
Please try:
First add a new column to the parameter table:
Then create a new sliceer with the Flag column:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-jianboli-msft Perfect solution!! So easy, and clean. I asked ChatGPT this same question and it gave me a bunch of ridiculous solutions....
Thank you!
Hi @Anonymous ,
Please try:
First add a new column to the parameter table:
Then create a new sliceer with the Flag column:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
102 | |
92 | |
69 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
95 |