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.
Hey Everybody,
I am working on a weekly 2020 report that organizes each week by the month that the week is in.
Anyway, I am having difficulty removing column subtotals. As you can see below, my Power BI report is totaling per month and per year.
I only want this report to total per year, not per month. When I turn off the Column Subtotals in the Format paintbrush under Visualizations, all of the column subtotals are removed.
How do I turn off the monthly column subtotals without turning off the column subtotals for the whole year?
Thanks
Dan
Solved! Go to Solution.
@i820017 , In the subtotal you have the option - Subtotal - Column by level, Check if that can help
Provide your feedback and tips for new videos
Dax Series Tutorial Vs SQL Direct Query PBI Tips
We appreciate your congratulations.
@i820017 , In the subtotal you have the option - Subtotal - Column by level, Check if that can help
Provide your feedback and tips for new videos
Dax Series Tutorial Vs SQL Direct Query PBI Tips
We appreciate your congratulations.
It worked...thanks!!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |