Slicer with selection of Date Periods (Year, Quarter, Month) that come from multiple columns

[themistoklis]

Hello All,

Im trying to create a slicer where I can select the period that I want (e.g. year, month and quarter) and the the date period will be populated with the correct values (First column in image below).

The date periods (year, quarter, month) are stored in seperate fields in a Calendar table in the report

Although I have seen an article explaining the methodology on how to do it... im struggling to find it.

Any help will be much appreciated

[Jihwan_Kim · Accepted solution]

Hi, @themistoklis 

Please correct me if I wrongly understood your question.

Please check the below picture, link, and measure whether it is what you are looking for.

Qty Total =

SWITCH (

SELECTEDVALUE ( 'Period Slicer'[Type] , "Year"),

"Year",

CALCULATE (

SUM ( Sales[Qty] ),

TREATAS ( VALUES ( 'Period Slicer'[Period] ), Dates[Year] )

),

"Quarter",

CALCULATE (

SUM ( Sales[Qty] ),

TREATAS ( VALUES ( 'Period Slicer'[Period] ), Dates[Quarter & Year] )

),

"Month",

CALCULATE (

SUM ( Sales[Qty] ),

TREATAS ( VALUES ( 'Period Slicer'[Period] ), Dates[Month & Year] )

),

"Week",

CALCULATE (

SUM ( Sales[Qty] ),

TREATAS ( VALUES ( 'Period Slicer'[Period] ), Dates[Week & Year] )

),

"Checkagain"

)

https://www.dropbox.com/s/dthtmynqdlvj05x/themistoklis.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[ronaldbalza2023]

Hi @Jihwan_Kim . Awesome content. Would you mind to share the pbix file again? Thanks 🙂

[Jihwan_Kim]

Hi,

Thank you for your feedback.

Sorry to say that I could not find the file in my computer since it has been quite a long time I created this.

By the way, this solution is, I think, already an old way. Because now we have the feature called "Field Parameter" in Power BI Desktop. This is exactly providing the same and awesome solution for the above and it is much easier. There are many Youtube videos out there (less than 10 minutes) talking about "Field Parameter" in Power BI. You can simply search for the videos by entering "Field Parameter in Power BI".

[ronaldbalza2023]

Thanks @Jihwan_Kim 🙂 Appreciated your time on replying.

[themistoklis]

Hello @Jihwan_Kim 

This is what I needed. Thanks a lot for your answer.

This will save me time.