cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DeepakG Frequent Visitor
Frequent Visitor

Slicer to filter data by Day,Month,Year

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.

Date- series.PNGsample 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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Slicer to filter data by Day,Month,Year

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

3 REPLIES 3
adetogni Senior Member
Senior Member

Re: Slicer to filter data by Day,Month,Year

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?

Community Support Team
Community Support Team

Re: Slicer to filter data by Day,Month,Year

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

DeepakG Frequent Visitor
Frequent Visitor

Re: Slicer to filter data by Day,Month,Year

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

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)