Re: SubHeader to Matrix Viz

ak77 · ‎08-17-2023

Hi all .

i have above single matrix table where time series are displayed. my client needs a subheader for each section of the table

Each Section is derived from field parameters

Please help if this is possible for Matrix Viz

parry2k · ‎08-21-2023

@ak77 I will work on it when I get a chance.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k · ‎08-17-2023

@ak77 I don't have anything handy but I surely did it in the past. If you can share a sample pbix file with a few measures in it and I can update pbix file with the solution.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

ak77 · ‎08-17-2023

Thanks a lot in advance.

Please find the link of pbix: https://drive.google.com/file/d/1gRbHJuKNvB4ixjqkMn4O00qfZsFcA0m4/view?usp=drive_link

ak77 · ‎08-21-2023

@parry2k , Please let me know if you wer able to achive the headers with the sample pbix provided .Thanks again

parry2k · ‎08-17-2023

@ak77 afaik it will be complicated using FP but can surely work with calculation groups if you are ok to use those.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

ak77 · ‎08-17-2023

Thanks @parry2k . do u have a sample pbix ..can u please pass

ak77 · ‎08-17-2023

@parry2k : these are measures

parry2k · ‎08-17-2023

@ak77 the sub header, are these measures or do you have these as columns in your model?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.