Streamline visualization table

[Nelson_Marquez]

Hi community.

I)

I have a visualization table built with two tables/queries. It's about the flow of some products, showing the possible origins or load locations for a given destination or unload location.

It happens that on first column I put my unload location, 'Nome do local', then I have a column for product source in 1st scenario, called 'R1 Local de carga'. For the same location defined in first column, this 'R1 Local de carga' may have one, two or even three entries. Until then, fine, no issues with that. However, When I add another field, which represents the possible sources for the same unload location but under a different scenario studied, called 'R2 Local de carga', it appears to make this latter field dependent on the 'R1 Local de carga', repeating all the origins for each of the origins of the 'R1 Local de carga'. I understand this might sound confusing, so here's a screenshot:

Ideally, I'd like to build a table with the following:

Nome do local [=destination]  R1 Local de carga [=Source 1]  R2 Local de carga [= Source 2]

ES09-Alicante-CLH depot                Bilbao-Refinery                                   Bilbao-Refinery

ES09-Alicante-CLH depot                Cartagena-Refinery                             Cartagena-Refinery

...                                                      ...                                                          ...

II)

As a second query, I'd like to know if it is possible to identify differences between the source fields. I know these are text fields and that PowerBI only does this easily with conditional formatting in numerical fields. I have previously tried to attribute to each location an index number, however there is no way to compare both column...

Help would be much appreciated.

Thanks and regards

[LP2803]

Hi,

for your first question, I see that the "R2 Volume total (m3)" is what making the table to repeat the values.

you may need to aggregate (sum/average) this column to not to get the repeatations.

for the second question, could you please elaborate more what are you trying to compare?

[Nelson_Marquez]

@LP2803 thanks for your response.

Even if I remove that field I still have the same issue.

I'd like the source fields to be subjacent just to the destination field, not to the other source field.

Thanks and regards

[LP2803]

For your second query,  the below is what you are trying to achieve?

[LP2803]

Ok. I created a measure to see if the Source1 and 2 are similar and then applied that as a filter as below.

Let me know if this answers your requirement.

[Nelson_Marquez]

That would be the ideal, however I'm building my bisualization table with two different source tables. I guess we can't create measures in the visualization tables (Report tab), right?

[LP2803]

You can create measures in Report Tab by clicking on the ... eclipses next to the table name and clicking on "New Measure" or by selecting "New Measure" from Home tab.