Forum Discussion
Helper IIISlicer - Year + Quarter + Month
I have a date field in my data model. Subsequently I created 3 columns derived out of the date field - Year, Quarter and Month and then created a Hierarchy.
Now when I pull in the date hierarchy in the slicer it shows in Year + Quarter + Month format.
Example: If I select March 2020 it shows 2020 (Year) + Q1 (Quarter) + March (Month) in the slicer.
If I select Q2 it shows 2020 (Year) + Q2 (Quarter).
Is there a better way to represent slicer as this uses up a lot of real estate? Something like Q2 2020.
2 Replies
- amitchandak
Super User
v-xuding-msftCommunity Support
Hi kabra_ashish ,
You turn on the option of "Show summary" and you want to change its format. Right? If so, unfortuanately, it is not supported to do it for now. You could turn it off or you could submit a new idea to get the feature implememted. https://ideas.powerbi.com/ideas/search-ideas/
A tip of date table:
Power BI Desktop works behind the scenes to automatically identify columns that represent dates, and then creates date hierarchies and other enabling metadata for your model, on your behalf.
If you want to create your own date table, In Power BI Desktop, you can specify the table you want your model to use as its date table, and subsequently create date-related visuals, tables, quick measures, and so on, using that table's date data. When you specify your own date table, you control the date hierarchies created in your model, and use them in quick measures and other operations that use your model's date table.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables
