Forum Discussion
Helper IHide column matrix
Resident Rockstar
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
- Hanspw
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
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