cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

disaggregated Data

Hi everybody

 

I’m trying to create a table and, I don’t know why, I can’t disaggregate all the rows.

In the database, I have 7 rows with the same id, date,  description and value and I want that the table contains all the 7 rows. Instead, the table aggregate the information and only appears one line with the amount.

What I want

Id

Date

Descr

Value

1029

17/07/2019

345

750.00

1029

17/07/2019

345

750.00

1029

17/07/2019

345

750.00

1029

17/07/2019

345

750.00

1029

17/07/2019

345

750.00

1029

17/07/2019

345

750.00

1029

17/07/2019

345

500.00

 

 

 

What I have

Id

Date

Descr

Value

1029

17/07/2019

345

750.00

 

Noted that in the setting I have already set the variables to “not summarize”.

In order to overcome this issue I create a function “row_number”  but with this function my importing data settings through to “import” instead direct query”

 

Do you have another solution to this issue?

 

Thanks

1 ACCEPTED SOLUTION
Solution Sage
Solution Sage

Hi @Ramalhomarcelo ,

Based on my researching, it is still not supported to display the Duplicate data in Table visualization, as a workaround, we can create an index for this table in Power Query:

hdDx3Akxiq.gif

Best Regards,

Teige

View solution in original post

1 REPLY 1
Solution Sage
Solution Sage

Hi @Ramalhomarcelo ,

Based on my researching, it is still not supported to display the Duplicate data in Table visualization, as a workaround, we can create an index for this table in Power Query:

hdDx3Akxiq.gif

Best Regards,

Teige

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors