Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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
@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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |