cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anandav
Continued Contributor
Continued Contributor

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

 

 

7 REPLIES 7
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
OvidiuNeacsu
Helper III
Helper III

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"

Greg_Deckler
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




anandav
Continued Contributor
Continued Contributor

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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




anandav
Continued Contributor
Continued Contributor

@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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors