Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Please post data. We can't work on an image. Also show a depiction of the expected outcome
Proud to be a Super User!
Paul on Linkedin.
ID | GUY | DAY | DATE | HOUR | CLIENT 1 | CLIENT 2 | COUNTRY | LEVEL | SELLER |
1 | SALE | FRIDAY | 27/08/2021 | 22:15 | ARMASA | EXTRUAL | SPAIN | 1 Series | FRANCISCO |
2 | SALE | FRIDAY | 27/08/2021 | 19:30 | EXTRUAL | STEELS C | SPAIN | 2nd | ANTONIO |
3 | SALE | FRIDAY | 27/08/2021 | 21:30 | METAL | ETD | SPAIN | 1 Series | ANTONIO |
4 | SALE | SATURDAY | 28/08/2021 | 17:30 | UNION | ARMASA | SPAIN | 3 Series | AITOR |
5 | SALE | SATURDAY | 28/08/2021 | 19:30 | IRONS BARCELONA | ALGECIRAS | SPAIN | 2nd | OSCAR |
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?
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.
can you post sample data and a depiction of the expected outcome?
Proud to be a Super User!
Paul on Linkedin.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |