Month and year in one slicer

[Hasan_iba]

Hello Power BI Experts. Hope all of you are doing great!! I am currently having an issue. I am looking to have one single slicer which will contain both years and months. At the moment, I have not been able to find a solution to this. Is there a way to achieve what I am looking for? Here is the link to the pbix file I am working with: https://drive.google.com/file/d/0B0XwYvmbIN12M3ZLNlAwM0NVVFk/view?usp=sharing

A prompt solution will he highly appreciated. Thanks

Hasan

[prathy · Accepted solution]

Hi ,

Have you looked into Power Bi Custom Visual Time line, that may solve your issue - https://app.powerbi.com/visuals/show/Timeline1447991079100

Or you can use HierarchySlicer - https://app.powerbi.com/visuals/show/HierarchySlicer1458836712039

Regards,

Prathy

[v-shex-msft · Accepted solution]

Hi @Hasan_iba,

You can simply add a calculated column "month year" to your calendar table, then use it as the source of slicer.

Month Year= FORMAT([Date],"mmmm yyyy")

Regards,

Xiaoxin Sheng

[Anonymous]

Hi,
With this approach, you cannot analyze data in terms of Y-1 because the year and month cease to be date type and become text.

[Anonymous]

---

You can simply add a calculated column "month year" to your calendar table, then use it as the source of slicer.

Month Year= FORMAT([Date],"mmmm yyyy")

Regards,

Xiaoxin Sheng

---

IMO this is a terrible "solution". Doing this makes the field a text field by default meaning the values sort alphabetically in the slicer, which is a real pain for users. Additionally, the slicer only provides List and Dropdown options.

Alternatively, if you change the data type from text to date the slicer then reverts to day level selections and therefore it doesn't meet the need of selecting a Year + Month data range... E.G. "2016 January" to "2017 October"

The other Timeline Slicer add-in that was suggested is right on the money.

[prathy · Accepted solution]

Hi ,

Have you looked into Power Bi Custom Visual Time line, that may solve your issue - https://app.powerbi.com/visuals/show/Timeline1447991079100

Or you can use HierarchySlicer - https://app.powerbi.com/visuals/show/HierarchySlicer1458836712039

Regards,

Prathy

[Anonymous]

Dear @prathy,

Which visual did you use for your Filter?

Can you show me please?

Thanks & Regards,

ManNVSM.

[prathy]

Hi,

It is - https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?src=office&tab=Overview

Regards,

Prathy

[Anonymous]

Thank you @prathy

[Hasan_iba]

Hi @prathy, Thanks for the suggestion. Will have a look into it. The timeline looks great. It should do the job. Thanks again!!