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

Issue with values in table visualisation

Hello all

 

I have data sitting in 2 data tables as below:

 

Table 1

Date         Till     SalesOpening

1/9/2019  AO1   45

2/9/2019  AO1   78

 

Table 2 

Date          Till    SalesClosing

1/9/2019   AO1  55 

1/9/2019   AO1  65

 

I have created a relationship between dates which works when I use the table visualisation, however i get the result below:

Date          Till     SalesOpening     SalesClosing

1/9/2019   AO1   45                       120

 

The Closing values automatically sum, but I would liek the below:

Date          Till     SalesOpening     SalesClosing

1/9/2019   AO1   45                       55

1/9/2019   AO1   45                       65

 

Essentially listing all closing values, whilst retaining the singular opening value.

 

Is this possible?

 

Thanks for all your advice.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Issue with values in table visualisation

Hi @featleyd 

 

you can change the Data Type  to text 

 

image.png

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Issue with values in table visualisation

Hi @featleyd 

 

All visual in Power BI implicitly group your data, to see an individual record you need to add record id or Index value to both main table and later visual table.  

you can add index in query editor as below.

image.png

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

Highlighted
featleyd Regular Visitor
Regular Visitor

Re: Issue with values in table visualisation

Thank you @Mariusz 

 

How would you then use the Idex column in the resulting table visualisation though?

vik0810 Member
Member

Re: Issue with values in table visualisation

just right click on the field "SalesClosing" in the definiton of your table visual and choose "do not summarize"

Super User
Super User

Re: Issue with values in table visualisation

Hi @featleyd 

 

you can change the Data Type  to text 

 

image.png

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 351 members 3,202 guests
Please welcome our newest community members: