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

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

Reply
Sabareeshwari
Helper I
Helper I

Power BI Report Filtering Issue while using Measure

i have a PowerBI Report which have a value like the below Image.

Sabareeshwari_2-1704346437985.png

TypeDivisionDivision TargetDivision Target AchievedArea TargetArea Target AchievedLG TargetLG Target Achieved
Life GroupDivision 422410200
Life GroupDivision 321510400
Life GroupDivision 42246200
Life GroupDivision 12145100
Life GroupDivision 121410100
Life GroupDivision 22746200
Life GroupDivision 321510400
Life GroupDivision 22749100
Life GroupDivision 42246200
Life GroupDivision 22747100
Life GroupDivision 321510400
Life GroupDivision 22746200
Life GroupDivision 321510400
Life GroupDivision 422410200
Life GroupDivision 32157100
Life GroupDivision 12146200
Life GroupDivision 12146200

i have calculated Division Target and Division Achieved with following Measures:

DivisionTarget = SUMX(
    SUMMARIZE(
        Target,
        Target[Division],
        "DivTarget", MAX(Target[Division Target])
    ),
    [DivTarget]
)
DivisionAchieved = SUMX(
    SUMMARIZE(
        Target,
        Target[Division],
        "DivTargetAch", MAX(Target[Division Target Achieved])
    ),
    [DivTargetAch]
)
 
Using Clustered Column Chart we have achieved showing Division Target and Division Achieved. in X-axis kept Type and in
Y-Axis kept Division Target and Division Achieved.
 
It results show like below Chart in PowerBI Report.
Sabareeshwari_1-1704345167130.png

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.

4 REPLIES 4
Anonymous
Not applicable

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.

Ritaf1983
Super User
Super User

Hi @Sabareeshwari 

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Hi  @Ritaf1983 ,

 

   I have edited the post with data's . Kindly check and suggest any solution.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.