Forum Discussion

gyeea84's avatar
gyeea84
Regular Visitor
5 years ago
Solved

Dynamic report with default slicer

Hi, 

 

I have question on using default value in slicer. I'm building a weekly report which showing current week and its corresponding working day. User is able to select any working day within the week and KPIs will reflect the result based on the selected date. I would also like to default the KPI to show data based on last refresh date if no date is selected. 

Here is sample layout: 

Work had done so far: 
- I am able to display the result of the slicer, card, and pie chart based on default last refresh date with the help with measure. The data will change when user select one of the date from the slicer. 

 

Problem is the "matrix chart", it always show all records for the given week, instead of last refresh date. I tried create a new column saying if last refresh date = date in calendar table, then 1 else 0 and apply this matrix chart filter. By doing this, it will ALWAYS show only last refresh date record even if I choose different date from the slicer. 

 

So, how is it possible to solve that all visual showing result of last refresh date, and dynamically change the result when user select date from the slicer?

 

Hope to hear from some expertise here. Thanks in advance. 

 

Regards,

Gan.

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi gyeea84,

    AFAIK, current power bi slicers not support to set default value of dynamic value.

    I'd like to suggest you refer to the following link to add a calculated column to check the date value and return tag, then use this column to create slicer and savleh the change into bookmark.

    Slicer default to latest date of a column 

    Slicer filter ranges will changes when Dax expressions re-calculated based on the current date.
    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi gyeea84,

    AFAIK, current power bi slicers not support to set default value of dynamic value.

    I'd like to suggest you refer to the following link to add a calculated column to check the date value and return tag, then use this column to create slicer and savleh the change into bookmark.

    Slicer default to latest date of a column 

    Slicer filter ranges will changes when Dax expressions re-calculated based on the current date.
    Regards,

    Xiaoxin Sheng