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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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!:
The Definitive Guide to Power Query (M)

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!:
The Definitive Guide to Power Query (M)

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors