Forum Discussion
Two or more Column name in one Axis
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 :)
2 Replies
v-piga-msftResident Rockstar
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