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

Power BI Table Visual not showing double rows

Hi all

 

I've been searchig for a while now, and I think I'm missing a simple property but I can't figure out where to find it...

I'm searching for the ability to show all records (not only the distinct records) in my Table visual.

 

My datasource is an excel file with these values

 

Name | Value | Id

A        | 1        | 1

B        | 2        | 2

C        | 3        | 3

A        | 1        | 4

 

In my table I only want to display columns Name and Value.

When I do so, my last record with Id 4 isn't visible. 

The result is:

Name | Value 

A        | 1        

B        | 2        

C        | 3        

 

If I add the Id column to the Values of my table, all records are visible.

 

I've already set the 'Don't summarize' setting fo the Name and Value column.

 

Any ideas?

 

Thanks in advance!

9 REPLIES 9
Community Support Team
Community Support Team

Re: Power BI Table Visual not showing double rows

Hi @jeroenc,

 

I could reproduce your scenario, but I think that's by design.

 

Normaly, if you don't drag ID to visual, Name A only match Value 1 so it only show one distict row.

 

If you show count of Value, you will see 2 like below.

Capture.PNG

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jessica_Seiya Established Member
Established Member

Re: Power BI Table Visual not showing double rows

A workaround would be created a calcuated table to group the data by name and value.

 

See the example below.

 

GroupbyName = GROUPBY('Group','Group'[Name],'Group'[Value])

2018-06-21_13-24-07.png

 

jeroenc Frequent Visitor
Frequent Visitor

Re: Power BI Table Visual not showing double rows

Hi @v-piga-msft@Jessica_Seiya

 

Both thanks for the reply, but we are searching for a way to display all rows without grouping and without adding the unique Id column.

 

Any other solutions?

 

Thanks!

zlokesh Member
Member

Re: Power BI Table Visual not showing double rows

Really nice execerise , i tried 1-2 hours, change data types, change filters and...  but did not get.

Curious to know the solution.

Highlighted
MattieG72MP Regular Visitor
Regular Visitor

Re: Power BI Table Visual not showing double rows

Hi All

 

Is there any movement on this topic?

I also want to display all rows in a table but without the ID as this takes up valuable space in the model!!

 

Thanks

Mattie

jeroenc Frequent Visitor
Frequent Visitor

Re: Power BI Table Visual not showing double rows

Hi @MattieG72MP

 

No progress yet Smiley Sad

MattieG72MP Regular Visitor
Regular Visitor

Re: Power BI Table Visual not showing double rows

That is not great is it.

I have 10s of megabytes of IDs in my model which is restricting use of some data.

 

Let's hope there is some progress soon.

Community Support Team
Community Support Team

Re: Power BI Table Visual not showing double rows

Hi @jeroenc,

 

By my research, it seems that this is by design that won't show the duplicate rows on Power BI.

 

You could post your idea in Power BI idea froum and add your comments there to improve Power BI and make this feature coming sooner.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI Table Visual not showing double rows

@jeroenc

@v-piga-msft  Is there any proper solution to this?  I thought by adding a unique column to table like index column we can have all rows included and as a workaround, if dont want to show that index column in table., we can format the heading and values color so we can hide it