Forum Discussion
Matrix sub headings
Does anyone know how to create subheadings on matrix columns e.g.
Where Actual, Forecast, etc are measures. Preferably without having to duplicate data as this is already a huge dataset.
Or maybe a custom visual that can achieve this?
Thank you 🙂
Hi Anonymous ,
According to your requests, which may not be possible. But you can still consider my suggestion:
1.1 Create a column to realize, please see the 'Column1' in the table:
1.2 Use 'Drill' feature of Power BI Desktop:
2.1 I kow your subtitle are measures, if you use measures, the effect may not be the same as you think:
Best Regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- v-lionel-msftCommunity Support
Hi Anonymous ,
According to your requests, which may not be possible. But you can still consider my suggestion:
1.1 Create a column to realize, please see the 'Column1' in the table:
1.2 Use 'Drill' feature of Power BI Desktop:
2.1 I kow your subtitle are measures, if you use measures, the effect may not be the same as you think:
Best Regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Thanks Lionel,
I agree that it's probably not possible with measures. But making a seperate calculated summary table and using that for the visual in your first method may work. I'll give it a shot.
Thanks again,
Nicole