Forum Discussion
Keep Trend Axis on KPI Visualizations while changing date
- Anonymous5 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:
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
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:
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