Forum Discussion
Hide column matrix
It is a limitation in Power BI. There is not straightforward option/feature to make the column label dynamic.
As workaround,
Considering you fixed the number of columns (Last Year and YTD).
- Create 2 measures to get the last year and current year
- Created 2 card visuals and place them on Matrix visual (on top of the columns)
- Make the required UI changes
Note: when you export data from the matrix visual, it will still have last year and YTD as column names
Thanks,
Siva Mani
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?
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.
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