Streamline visualization table

Question

Hi community.&nbsp;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:&nbsp;Ideally, I'd like to build a table with the following:&nbsp;Nome do local [=destination]&nbsp; R1 Local de carga [=Source 1]&nbsp; R2 Local de carga [= Source 2]ES09-Alicante-CLH depot&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bilbao-Refinery&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bilbao-RefineryES09-Alicante-CLH depot&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cartagena-Refinery&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Cartagena-Refinery...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...&nbsp;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...&nbsp;Help would be much appreciated.Thanks and regards&nbsp;

lp2803 · Answer

Hi,&nbsp;for your first question, I see that the "R2 Volume total (m3)" is what making the table to repeat the values.&nbsp;you may need to aggregate (sum/average) this column to not to get the repeatations.&nbsp;for the second question, could you please elaborate more what are you trying to compare?

nelson_marquez · Answer

LP2803&nbsp;thanks for your response.&nbsp;Even if I remove that field I still have the same issue.&nbsp;I'd like the source fields to be subjacent just to the destination field, not to the other source field.&nbsp;Thanks and regards

lp2803 · Answer

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

nelson_marquez · Answer

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 · Answer

Ok. I created a measure to see if the Source1 and 2 are similar and then applied that as a filter as below.&nbsp;Let me know if this answers your requirement.&nbsp;&nbsp;

Forum Discussion

Streamline visualization table

6 Replies

Related content

export from visual table

Table visual error

Table Visual not Matching Calculated Visual

Table Visual Sorting

PowerBI - Matrix table, hide values used only for a visual calculation