Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Table Visualization That Groups All The Repeating Rows

Hi guys, 


My stakeholders want to export data from the table visualizations I deliver to them. One thing that can become very confusing is the repeating information that keeps appearing. Is there a way to Deliver the same information but more user-friendly?


This is a sample of how the table looks: 




Is there a visualization that will deliver the data (export as CSV/XLSX) like this or in a similar fashion?




I tried the Matrix way, but when they export data, it still looks like the 1st image.

Let it be known that there are actually more columns and hundreds of rows involved in the report. 


Thanks a lot for your assistance!




You can check a collection of Power BI visuals in the store. There are more than 200 differen visuals so there is a chance that you will find something suitable.


Kind Regards,


Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals

Regular Visitor

I think you should bring the data similar fashion from Source. I don't think any conditional option you can use at cell level.

Helpful resources

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors