Issue with values in table visualisation

[Anonymous]

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.

[vik0810]

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

[Mariusz]

Hi @Anonymous 

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.

Best Regards,
Mariusz

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

Please feel free to connect with me.

[Anonymous]

Thank you @Mariusz 

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

[Mariusz · Accepted solution]

Hi @Anonymous 

you can change the Data Type  to text 

Best Regards,
Mariusz

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

Please feel free to connect with me.