Forum Discussion

rohank11's avatar
rohank11
Frequent Visitor
1 year ago
Solved

SELECTEDVALUE function not working in bar graph

This dax gives below bar graph Total Active Patients in current month =         VAR TOTALVALUE =   (                 [New Patients running total in Date] - [Drop off Patients running total in Dat...
Need Help
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    Hi rohank11 
    Thanks for raising this Fabric Community
    Your ALL-status bars went missing because SELECTEDVALUE returned a single status (“Declined” or “Dropped”) in May’s context, and your SWITCH sent those to zero. To show the full running-total when nothing (or multiple statuses) is selected, use one of these patterns:

    Total Active Patients =
    IF(
    HASONEVALUE( Append1[PatientStatus] ),
    SWITCH(
    VALUES( Append1[PatientStatus] ),
    "Declined", 0,
    "Dropped", 0,
    [Total Active Patients in current month]
    ),
    [Total Active Patients in current month]
    )

    For more details, see the official docs:
    • SELECTEDVALUE → https://learn.microsoft.com/dax/selectedvalue-function-dax
    • HASONEVALUE → https://learn.microsoft.com/dax/hasonevalue-function-dax
    • SWITCH → https://learn.microsoft.com/dax/switch-function-dax


    If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
    Best Regards,
    Community Support Team _ C Srikanth.

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

Hi rohank11 

I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!


Best Regards,
Community Support Team _ C Srikanth.