Hierarchy slicer

[KatkaS]

Hello,

I searched, but didn't find answer for below..:

When I drill down in my Hiearachy slicer, options (months) don't pop up as in the "normal" Slicer, please see below screen prints.

Thank you very much!

[v-yulgu-msft]

Hi @KatkaS,

I didn't encounter this problem on my side.

In your scenario, please remove the Hierarchy Slicer visual, restart your Power BI desktop and import this custom visual again for a test.

Regards,

Yuliana Gu

[tarunsingla]

You can try creating a calculated column for the month and use that as an additional slicer next to the Year slicer.

Regards,

Tarun

[KatkaS]

Thank you very much, Tarun, for your time and reply!

But it is not really what I ment (but your reply helped me to solve another problem I also had with months!:)))

I will try to be more precise of explanation of my problem about hierarchy slicer

(and sorry if I missed something from your reply, I'm new to PBI, learning mainly from tutorials):

I want my hierarchy slicer (in the attachment called "Reporting period") to have the same appearance as the "normal" slicer.

(if I select a year of my hierarchy slicer I have to scroll down in the table to be able to choose the month which is not well-arranged, while in the normal slicer selection pops up and is easily accessed).

Thanks a lot again!

[tarunsingla · Accepted solution]

Not sure if I understand it correctly what you meant by normal slicer. But here's another approach that you may use to have month and year in a single slicer.

1. Create a calculate column for Year Month, using FORMAT function.

2. Change the DataType of this new calculated column to Date and set Format to Month, Year.

Hope this helps.

Regards,

Tarun

Did I answer your question? Mark my post as a solution!

[KatkaS]

Thank you, Tarun, very much again for your time!:)

But it's still not what I mean, sorry!:) It's not about the content of the graph, but about appearance - in the Hierarchy slicer (containing years and months in my case) I have to scroll down within the graph, in the Slicer (HUBs in my case) the options pops up, so I can easily select them..

Thank you:)

[tarunsingla]

Is it about how the data is showed in the slicer? List vs Dropdown ?

If yes, you can change that from the little icon on the top right corner of the slicer visual.

Regards,

Tarun

Did I answer your question? Mark my post as a solution!