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.
Hello BI Experts,
For example:
I have 3 Columns in a table-Name, designation and his net sales amount.
Name | Designation | Net Sales |
Mayank | ZSM | 10,000 |
Suresh | RSM | 6,000 |
Amit | RSM | 6700 |
Jahnvi | ZSM | 12,000 |
Manpreet | Asm | 2,000 |
Vidhya | ASM | 1,000 |
Amol | ASM | 1,500 |
Karishma | ASM | 1,670 |
Tarang | RSM | 5,600 |
Abhijeet | ZSM | 13,000 |
Vrinda | ZSM | 11,500 |
Satyam | ASM | 2,100 |
Now i Want to Show Position wise Sales Amount in a histogram in power BI
For this i can have a filter of Positions. But what column i need to take in X axis so that when i click on ASM, all ASM person names has to show up in histogram with its sales amount. Similarly if i click on RSM filter then all RSM Person names has to show up in same histogram with their corresponding amount.
Please let me know how can i do this in power BI
Thanks in Advance 🙂
Solved! Go to Solution.
Hi @Anonymous ,
Do you want to get the output below?
If it is, you could create the Stacked column chart like below.
If not, please share your desired output so that I could understand your requirement better and then help further on it.
Best Regards,
Cherry
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 | |
105 | |
78 | |
67 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
83 | |
70 |