Forum Discussion

northcity4's avatar
northcity4
New Member
1 year ago
Solved

Generate Cumulative Count Tooltips over missing inputs

Kindly let me know if this question is outside of PowerBI's technical capabilities. Goal: Have PowerBI's Tooltip show the value on a line chart, even for areas where the x-value may not exist. Here...
  • v-kpoloju-msft's avatar
    1 year ago

    Hi northcity4

    Thank you for reaching out to the Microsoft fabric community forum. Also thanks Greg_Deckler, for his inputs on this thread. I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it.

    Dax Measure for Cumulative Count:

    Cumulative Count =
    
    VAR CurrentX = SELECTEDVALUE('Dim_X'[Value])
    
    RETURN
    
    CALCULATE(
    
        SUM('fact_events'[cnt_flag]),
    
        FILTER(
    
            ALLSELECTED('fact_events'),
    
            'fact_events'[x_value] <= CurrentX
    
        )
    
    )


    Outcome:

    I am also including .pbix file for your better understanding, please have a look into it:

    Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

    Thank you for using the Microsoft Community Forum.