Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
27 |
User | Count |
---|---|
92 | |
50 | |
44 | |
40 | |
35 |