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 have a pivot table with 5 measures. I have to hide subtotal values for only sale %. is there any way to convert sale % sub total value to 0 or completly hide the value.
Thanks
Solved! Go to Solution.
You can use this pattern to do that.
Yes. You can make a new measure like this that references your existing measure and use it instead.
Sale % No subtotals = IF (HASONEVALUE(Table[Company Name]), [Sale %])
Pat
Hi @ppm1 Thanks for your help. It's working fine for subtotals but totals also showing blank along with sub totals. Is there any way to hide only subtotal and show total.
You can use this pattern to do that.
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |