March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I am showing in a Matrix the percentage of the valid supplier certificates (green + yellow against red) per center and i would like to show this only in the total section. The problem is that the measure is dispalyed and showing the same info multiple times (per Certificate status) as you can see it in the screen shot. How to remove the columns which i highlighted in red and keep only the one which i highlighted in green?
Solved! Go to Solution.
Hi @hdaoued ! Whenever you add a measure to the values box in a visual, Power BI always computes it for every available column (filtering context) and, to my knowledge, there is no way to customize or choose in which columns the measure will be computed. The work around I would do, would be something in the lines of:
1. In your "% of valid certificates" measures add a SWITCH() to show blank values in all rows except the total column (for example in my case I did it like this)
Avg Unit Price =
SWITCH(
TRUE(),
HASONEVALUE('Calendar'[Year]), BLANK(),
AVERAGE( Orders[UnitPrice] )
)
2. Go to the formatting pane of the visual -> Values -> Options -> Switch values to rows rather than columns
3. The end result will look something like this!
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Hi @hdaoued ! Whenever you add a measure to the values box in a visual, Power BI always computes it for every available column (filtering context) and, to my knowledge, there is no way to customize or choose in which columns the measure will be computed. The work around I would do, would be something in the lines of:
1. In your "% of valid certificates" measures add a SWITCH() to show blank values in all rows except the total column (for example in my case I did it like this)
Avg Unit Price =
SWITCH(
TRUE(),
HASONEVALUE('Calendar'[Year]), BLANK(),
AVERAGE( Orders[UnitPrice] )
)
2. Go to the formatting pane of the visual -> Values -> Options -> Switch values to rows rather than columns
3. The end result will look something like this!
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |