Forum Discussion
Edit Elements in Slicer Dropdown
Hi all,
I have a date slicer with year, quarter and month. I set up this slicer to be a dropdown. When i now select lets say January and close the dropdown, the element shows "2020(Year) + Q1(Quarter) + January(Month)". This takes quite a bit space, what i would like it to show is just the value like "2020 + Q1 + January".
Is this possible?
Regards,
Dennis
4 Replies
- mohammedadnant
Impactful Individual
Anonymous
It is not possible in the slicer, as this is the default setup,
If you need that then you have to create 3 seperate slicer dropdown 1 for year 1 for quarter and 1 for month.
by doing this you can get the expected result.
Thanks and hit the like button,
Mohammed Adnan
- Greg_Deckler
Community Champion
Anonymous - Perhaps try using the Column tools and the Format area to pick a different date format?
- amitchandak
Super User
Anonymous , not very clear. Can share some kind of screenshot.
Are you using https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/#_Hierarchical_slicer
Hello amitchandak ,
Here is a screenshot. So my slicer is set to be a dropdown with the fields "Year", "Quarter" and "Month". Now i selected 2020, Q1, January. When i close the slicer it shows like above "2020 (Year) + Q1 (Quarter) + Januar (Month)". I would like to remove the parts in brackets (which seem to be the field names) so that it shows "2020 + Q1 + Januar".
Thanks for your help,
Dennis
