Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.

NameDesignationNet Sales
MayankZSM10,000
SureshRSM6,000
AmitRSM6700
JahnviZSM12,000
ManpreetAsm2,000
VidhyaASM1,000
AmolASM1,500
KarishmaASM1,670
TarangRSM5,600
AbhijeetZSM13,000
VrindaZSM11,500
SatyamASM2,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 🙂

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous ,

Do you want to get the output below?

Capture.PNG

If it is, you could create the Stacked column chart like below.

stacked column chart.PNG

If not, please share your desired output so that I could understand your requirement better and then help further on it.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.