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 all,
Is there some way of hiding all values (subtotals and individual category values) from a column leaving just the grand total in the bottom?
What I mean is that I have this:
And I need it to show up like this:
The pink fields are subtotals for each country/group of categories.
Cheers,
J.
Solved! Go to Solution.
Here is one way:
Assuming:
Group of categories field = Table A[Group of categories]
Country field = Table B [Countries]
Variance measure = [Variance]
Use a measure along the lines of
Only totals =
SWITCH (
TRUE (),
ISINSCOPE ( 'Table A'[Group of categories] ), BLANK (),
ISINSCOPE ( 'Table B'[Countries] ), BLANK (),
[Variance]
)
Proud to be a Super User!
Paul on Linkedin.
Here is one way:
Assuming:
Group of categories field = Table A[Group of categories]
Country field = Table B [Countries]
Variance measure = [Variance]
Use a measure along the lines of
Only totals =
SWITCH (
TRUE (),
ISINSCOPE ( 'Table A'[Group of categories] ), BLANK (),
ISINSCOPE ( 'Table B'[Countries] ), BLANK (),
[Variance]
)
Proud to be a Super User!
Paul on Linkedin.
Worked as a charm, thanks 🙂
Please check out the Row Subtotals options in the visual. You can select which fields to show subtotals for. In this case, I have it turned off for Product but on for Category.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@JohnS1968 , Under the row subtotal, Remove all subtotal, other than the first level.
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |