Forum Discussion

Hanspw's avatar
Hanspw
Icon for Helper I rankHelper I
5 years ago

Hide column matrix

Hi.   I have created measures for last year and YTD values, and are showing them in a matrix. Everything is working ok. But i would like to show the actual year in the column header. The easiest wa...
Need Help
Hanspw's avatar
Hanspw
Icon for Helper I rankHelper I
5 years ago

Sounds strange to me that this dont work in power BI when it works in excel pivot, but i guess you are right.

 

The workaround could work but is not as dynamic as i would like. I have more columns lets say budget, forecast etc, and i would need to change the location of the card visuals dependens on where the columns are.  Also i may remember that the columns change location when you expand/drill on rows with longer text, so i guess that would offset the card visual from the acual column?

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Hanspw,

 

The workaround won't help in that case.

 

You can add notes with a combination of text boxes and card visuals (near the matrix). It will help users to understand what they are seeing.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Hanspw,

    Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng