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 there,
I have a calendar table that shows me the total spend by month with the upcoming months showing a forecast. I want to differentiate the months I have actual data for from the upcoming (or forecasted) months. So I used column headers to differentiate them like so:
However, I don't want the subtotals for "Actual" and "Forecast" to appear, but I do still want the grand total at the very right to stay. In other words, I need my column headers to be:
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
with "Actual" appearing over Jan to Sep and "Forecast" appearing over Oct to Dec. Any ideas on how to set this up? I played around with the turn off Column subtotals option, but it also removes the total at the end.
Solved! Go to Solution.
Hi @Anonymous,
We only could turn off all of the subtotals of column in Power BI Desktop currently.
Here is a workaround which also could achieve your desired output.
Turn off the Word Warp of Values and Column headers under formatting.
Then please refer to the option in this gif.
Best Regards,
Cherry
Hi @Anonymous,
We only could turn off all of the subtotals of column in Power BI Desktop currently.
Here is a workaround which also could achieve your desired output.
Turn off the Word Warp of Values and Column headers under formatting.
Then please refer to the option in this gif.
Best Regards,
Cherry
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |