Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |