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 want to display all the months (ResponsePeriod in this case) as columns and Month KPI as values for those columns and i have few other columns as headers in the table.
My Requirement is in place of Grand Total, i should be able to show the average of all these months. I have calculated the average measure and placed in values. However, that displays against each and every month as shown below.
:
expected outcome is :
Month 1 Month 2 Month 3 Month 4 Average
Any help would be greatly appreciated.
Thanks,
Nishanth.
Hi @Anonymous,
From your description, it seems the month column is placed in Column bucket of the matrix visual and there are two columns/measures Month KPI and Average placed in Values bucket, right?
Based on my test, as the Average is the Value of the matrix, it will display on each column group value level and column group total level, it's not possible to remove the Average columns on column group value level.
To work around the issue, we can set the Field Formatting for the measure/column Average like below to make the Average values in column group total invisible.
Best Regards,
Qiuyun Yu
Hmm.. this is a workaround i understand. Thanks for the response. But will not be a solution for my client.
Do you think we can have a custom visual built for the same?
Thanks,
Nishanth.
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |