Forum Discussion

rammy's avatar
rammy
Helper I
4 years ago

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

 

Need Help

2 Replies

  • rammy's avatar
    rammy
    Helper I
    4 years ago

    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

     

     

     

    this is the relationship status 

     

    please check  and help me 

     

    Thanks in adavance