Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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. O...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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.

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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