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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
rammy
Helper I
Helper I

How to create charts with unique data

Hi power bi family 

I am new to power bi, i have a problem relatd to tables and data, the scenario is a bi file having 3 table one if fact and 2 are dim(both have  bi-directional relationship) . after using this relation ship everything ok , but bar charts shows others data also like 1 person worked in 1 wo after some time another person taken full control of that work order . With this data if i add in bar chart it shows the same value in both persons after filtering indivisually also . Here your suggestions need , how can i show the value for one person only in chart level also . The output must show who is the manager of the wo, only the value needs to be shown for that person only. 

It does not matter who was the owner of that wo in past, but in present who is the owner of that wo , the value only shown for present owner only.

 

please help on this 

Thanks in advance

 

2 REPLIES 2
rammy
Helper I
Helper I

Hi @amitchandak  

 

Thanks for your replay

here the problem is , if you see in below image , there i am using  one work order id,after choosing that it shows related data . In left side table you can see 5 persons are (invovled) using that work order but the work order manager is one person which is " harsha". Now when i choose the id in 2 nd bar chart shows all people with same values because those are invovled or used but they are not managers of that . when i choose id at that time i need only manager data and that should be the output other people are not required in the visual. How can i restrict them in visual level . i hope u understand now

can u please help me on this 

please find below image

 

 

 

rammy_0-1655793511338.png

this is the relationship status 

rammy_1-1655794157130.png

 

please check  and help me 

 

Thanks in adavance

 

amitchandak
Super User
Super User

@rammy , not very clear. But you can use small multiples to show each individual

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-small-multiples

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors