Two or more Column name in one Axis

[Anonymous]

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 🙂

[v-piga-msft]

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

[Anonymous · Accepted solution]

Hi,
Thanks for updating me but i got the solution.
Thank you very much