Slicer to filter data by Day,Month,Year

[DeepakG]

Hi Team,

To explain my request is very simple (Dataset: Financial data set from Microsoft)

1. Display the sales by product based on the date slicers selected
2. Create a separate table Date series that contains the following data 

• Day
• Month
• Year

If we select the Day then it should display the day level data, Month - month level, Year - year level data. Could you please help me with this requirement, please.

sample data

Note: I tried the same requirement in this following method created 3 tables(month, year, day) based on the selection pane options I hide the tables and linked it by using bookmarks and it is working fine. 

[adetogni]

Maybe you didn't know that you can add the three levels (year, month, day) in the visual axis and use drill down/drill up?

[v-shex-msft · Accepted solution]

HI @DeepakG ,

I'd like to suggest you take a look at the following blog about dynamic attribute filter, it should suitable for your requirement:

Dynamic Attributes In A Power BI Report

Regards,

Xiaoxin Sheng

[DeepakG]

Thanka a lot @v-shex-msft . This link helped me to achive the scenario