Two-column ratio

Hi Syndicate_Admin 

a bar graph can put on the axis the two columns of clients together and when I filter in the table and the count appears to me all the times it was visited regardless of whether it was client 1 or client 2

I think this is a question of hierarchy, if you put client1&client2 into slicer, then you will see 2 levels in slicer hierarchy,

Similarly, in bar chart visual, the client1 is the first level, so when you filter in the table, the count will always display the level1 first, then level2 after you select "Go to the next level...", these 2 columns client1&client2 cannot appear in the same dimension at the same time. If they are the same dimension, you need to merge them into one column by using the function Unpivot .

If you need more help, please @ me.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Thank you very much, thanks to unpivot I have been able to solve the problem, also changing a relationship so that you can search in another table