Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Syndicate_Admin
Administrator
Administrator

Two-column ratio

If I have two columns with names of workers and I want it to show me the number of times that the client has intervened regardless of the posicon of the column as I have to do?

The example is that in each sale 2 sellers participate and I at the end want to show me in a graph the number of times that the seller has participated, and I can not

2 ACCEPTED SOLUTIONS
v-xiaotang
Community Support
Community Support

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,

vxiaotang_3-1631605551564.png

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 .

vxiaotang_5-1631605771557.png

 

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.

View solution in original post

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

View solution in original post

9 REPLIES 9
v-xiaotang
Community Support
Community Support

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,

vxiaotang_3-1631605551564.png

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 .

vxiaotang_5-1631605771557.png

 

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

PaulDBrown
Community Champion
Community Champion

Please post  data. We can't work on an image. Also show a depiction of the expected outcome 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






IDGUYDAYDATEHOURCLIENT 1CLIENT 2COUNTRYLEVELSELLER
1SALEFRIDAY27/08/202122:15ARMASAEXTRUALSPAIN1 SeriesFRANCISCO
2SALEFRIDAY27/08/202119:30EXTRUALSTEELS CSPAIN2ndANTONIO
3SALEFRIDAY27/08/202121:30METAL ETDSPAIN1 Series ANTONIO
4SALESATURDAY28/08/202117:30UNION ARMASASPAIN3 SeriesAITOR
5SALESATURDAY28/08/202119:30IRONS BARCELONA ALGECIRASSPAIN2ndOSCAR

GLJ_0-1631370005197.png

For example, 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

Sorry I can't actually see the image clearly. It would be best if you created an example of what you need in a graph in Excel. I'm not sure what you are trying to achieve.

What goes in the axis? What do you mean when you say you filter in the table? ...What is the calculation you need?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






On the axis at this time it only puts client 1, because although it allows porner both columns on the axis always shows the first one that is set, and what I would like is that client 1 and client 2 were unified to be able to look for results of the and show them the axis as a single column or action so that I returned the result of the total number of times that a client is seen

I still don't understand what you want to calculate. Please create a simple example in Excel and put it here.

PaulDBrown
Community Champion
Community Champion

can you post sample data and a depiction of the expected outcome?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






DATOS.png

That's my data and I want the graphs to represent the number of times we saw a client, but also respecting client 1 and client 2

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.