Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
I've a problem regardring PowerBI, which I've tried to illustrate in excel. I've a matrix with Department in rows and Priority in columns and Low, Medium, High and SUM in values. My problem is that I only want to show the yellow column and not the three red columns. Could anybody please help?
Thanks
Perhaps you can return BLANK() if there is a filter on Priority and oterwise return the value?
Measure = IF (ISFILTERED('Table'[Priority]); BLANK(); [MySumMeasure])
Hi @AlexITRelation ,
Go to FORMAT options of your matrix visual --> Select "SubTotals" --> Navigate down to "Per Column Level" and switch off totals for "Priority" column. By default you will have "Per Column Level" ON for your "Department" and "Priority" columns.
This should resolve the issue.
Thanks.
Hi @Pragati11
Thank you for taking your time to reply me.
It seems not to work. Notice that the SUM column is a calculated measure of Low, Medium and High since I want to illustrate the 'grand total' sum the totals (the yellow marked)
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |