Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
anandav
Skilled Sharer
Skilled Sharer

Repeating value in table rows

Hi,

I have data as shown below. 

I haveindicated the result I need to achieve. I need to avoid the repeated column values (actual data as many more columns for a given store with the same data).

 

Questions:

1] How can I avoid the repeated data for the same store but need to show the Comments in row?

2] When the Store and Comments are the same, Power BI does not show the duplicate rows. How can I show the duplicate rows?

 

Thanks for any help in advance.

RepeatingRowDetails2.jpg

 

 

8 REPLIES 8
jeremyking77
Helper I
Helper I

Hi @anandav @Greg_Deckler 


Basically what Greg said was correct, im just adding some more info,

Rather than add comments to the values, you can just add it to the rows on the matrix visual like this

2020-06-30 12_48_12-Untitled - Power BI Desktop.png

So to get this result you can do follow these steps, 

  1. Add the Matrix visual
  2. Drag all of the columns in to the "Rows" area of the Matrix visual
  3. Expand down to the lowest level in the heirarchy using this icon 
    2020-06-30 12_52_45-Untitled - Power BI Desktop.png
  4. Go to Row Headers > Stepped Layout > Change to Off
  5. Go to Row Headers > +/- icons > Change to Off
Anonymous
Not applicable

Did anyone find a solution to this? I am looking for a similar solution. I got 5 columns repeating because of the last 2 columns display unique data using multiple rows.

 

It is not a very user-friendly file to export at the end. 

hannats
Advocate II
Advocate II

In the matrix visual, go to "Row Header" and set the "Stepped layout" option to "Off"

This is exactly the setting I was looking for

Greg_Deckler
Super User
Super User

Hmm, maybe a Matrix visualization and a "don't summarize"? Can you post some sample data that can be easily copied instead of images?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler,

Here is the sample data:

Sample Data

Hmm, I think you are going to have to look to see if there is any custom visual that will get you there. I don't think what you want is possible given the default visuals.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler,

Will upload sample data when I get home as office blocks all public upload sites.

 

Tried to use matrix but was not very successful.

RepeatingRowDetails3.jpg

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.