Forum Discussion

hariepermana's avatar
hariepermana
Frequent Visitor
5 years ago
Solved

Keep Trend Axis on KPI Visualizations while changing date

Hello expert,   I need some suggestion for my KPI Visualization. On my Page there are Date Slice with dropdown type, i just wanted everytime i choose single date my KPI visualization keep showing a...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi hariepermana ,

    In my opinion, at least two data points are required to form a "trend". So when you select a single value in Slicer,the trend could not be shown.

    You could use Card visualization to display the selected value and overwrite the original value on KPI. Please follow these steps:

     

    1.Set the interaction between KPI and Slicer as "None".

    2. Adjust indicator size and color to make it as inconspicuous as possible.

    3. Use Card visual to display the following measure and then put it on KPI to cover up the indicator.

    Measure =
    CALCULATE (
        SUM ( 'sales'[Value] ),
        FILTER (
            ALL ( 'master calendar' ),
            'master calendar'[Date] = SELECTEDVALUE ( 'master calendar'[Date] )
        )
    )

    My final output looks like this:

     

    Here is the pbix file.

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.

     

    Best Regards,
    Eyelyn Qin