Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
i have a PowerBI Report which have a value like the below Image.
Type | Division | Division Target | Division Target Achieved | Area Target | Area Target Achieved | LG Target | LG Target Achieved |
Life Group | Division 4 | 22 | 4 | 10 | 2 | 0 | 0 |
Life Group | Division 3 | 21 | 5 | 10 | 4 | 0 | 0 |
Life Group | Division 4 | 22 | 4 | 6 | 2 | 0 | 0 |
Life Group | Division 1 | 21 | 4 | 5 | 1 | 0 | 0 |
Life Group | Division 1 | 21 | 4 | 10 | 1 | 0 | 0 |
Life Group | Division 2 | 27 | 4 | 6 | 2 | 0 | 0 |
Life Group | Division 3 | 21 | 5 | 10 | 4 | 0 | 0 |
Life Group | Division 2 | 27 | 4 | 9 | 1 | 0 | 0 |
Life Group | Division 4 | 22 | 4 | 6 | 2 | 0 | 0 |
Life Group | Division 2 | 27 | 4 | 7 | 1 | 0 | 0 |
Life Group | Division 3 | 21 | 5 | 10 | 4 | 0 | 0 |
Life Group | Division 2 | 27 | 4 | 6 | 2 | 0 | 0 |
Life Group | Division 3 | 21 | 5 | 10 | 4 | 0 | 0 |
Life Group | Division 4 | 22 | 4 | 10 | 2 | 0 | 0 |
Life Group | Division 3 | 21 | 5 | 7 | 1 | 0 | 0 |
Life Group | Division 1 | 21 | 4 | 6 | 2 | 0 | 0 |
Life Group | Division 1 | 21 | 4 | 6 | 2 | 0 | 0 |
i have calculated Division Target and Division Achieved with following Measures:
we used 3 slicers for filters like Division , Area and LifeGroup.
If we Filter Division , values in the chart modified based on the selection. But if we filter Area and LifeGroup there is no change in the Chart Visual.
Kindly suggest Solution to filter area and LifeGroup , based on that filter selection chart visual have to modify.
Hi @Sabareeshwari ,
Could you please tell me where the fields for all three slicers come from?
It is very helpful for me to test.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have 3 slicers - Division , Area and LG.
For Division Slicer , i used Division column.
For Area and LG slicers, i used column area and LG Name , which is not given in that above data. if u need that will share that data.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
146 | |
111 | |
109 | |
102 | |
96 |