Forum Discussion

patrickbrooks13's avatar
patrickbrooks13
Frequent Visitor
1 year ago
Solved

KPI Card visual showing wrong value when 'Select All' is used

I have a kpi card showing Secured and Potential Revenue by Month and Financial year, however when All is selected in Month slicer and Financial year slicer, the value is wrong it seems to be just sho...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    Hi patrickbrooks13 ,

    Thank you for raising this issue in the community.

     

    I have reproduced your scenario in Power BI Desktop and I’m happy to confirm that I was able to achieve the expected KPI card visual output when “Select All” is used in both Month and FinancialYear slicers.

    What I did:

    • Created a KPI visual for Secured Revenue and another for Potential Revenue
    • Built custom DAX measures using ALLSELECTED() to ensure totals across all selected months and years
    • Connected both visuals to a proper DateTable
    • Enabled “Select All” in the slicers

    Result:

    • Total Secured Revenue: 11,800
    • Total Potential Revenue: 13,300
      (as expected, summing all selected months and years)

    To help you further, I’m attaching the .pbix file used for testing this scenario.
    Feel free to download it and adapt it to your data model.

     

    If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.


    Thank you.

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

Hi patrickbrooks13 

As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?

 

And if the provided information meets your requirements, you can Accept the solution and also give Kudos on that reply. It helps other users who are searching for this same information and find the information.

 

Your understanding and patience will be appreciated.

patrickbrooks13's avatar
patrickbrooks13
Frequent Visitor
1 year ago

Hi, unfortunately, this hasn't worked, I'm still struggling to get this fixed. Thanks

 

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    1 year ago

    Hi patrickbrooks13 ,

    Thank you for raising this issue in the community.

     

    I have reproduced your scenario in Power BI Desktop and I’m happy to confirm that I was able to achieve the expected KPI card visual output when “Select All” is used in both Month and FinancialYear slicers.

    What I did:

    • Created a KPI visual for Secured Revenue and another for Potential Revenue
    • Built custom DAX measures using ALLSELECTED() to ensure totals across all selected months and years
    • Connected both visuals to a proper DateTable
    • Enabled “Select All” in the slicers

    Result:

    • Total Secured Revenue: 11,800
    • Total Potential Revenue: 13,300
      (as expected, summing all selected months and years)

    To help you further, I’m attaching the .pbix file used for testing this scenario.
    Feel free to download it and adapt it to your data model.

     

    If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.


    Thank you.

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    1 year ago

    Hi patrickbrooks13,

     

    I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.

     

    Thank you.