The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Good day to all,
Using the example from enjoysharepoint below:
I am unable to find a suitable way to show the row header for the second line. In the example above, it would be something like 'Region' in a row to match Central, East, etc. 'Segment' would be below it.
I have a measure in the Values.
I discovered that if I used the "Separator trick" for better formatting, it will actually show that header. (Trick = Using a measure to add a '|' then coloring it the same as the background to give a visual appearance of separating sections.
Downside of this is when you know people will extract the data and they see the separator columns in the Excel file....)
Am I missing a setting somewhere to get that last header in the columns to show up?
Note that I find similar examples to the one above in Microsoft's Matrix documentation.
Thanks,
Trent
Solved! Go to Solution.
That's how they chose to implement it, probably to save some screen real estate. If you feel passionate about this please consider raising an idea at https://ideas.powerbi.com
That's how they chose to implement it, probably to save some screen real estate. If you feel passionate about this please consider raising an idea at https://ideas.powerbi.com