Forum Discussion
calendar date visual
hi team
i have the date dimension and i need to show in the power bi report . I should not use the sclier here since i need to select only date and for look and feel it should be same as calendar diagram . Is there any visual which can support it?. I used chiclet slicer but my dates are more and it not showing in good manner .
i need something like below where user can select only one date . Is there any custom visual like below . I cannot have between dates . Like my user should select only one date as below .Hope you understood .
Click on slicer visual
Drag into the slicer "field" box the "Day Number" column from your date table.
Click on the format option for the slicer (looks like a rolling paint brush)
Open up General
Select Horizontal Orientation.
Thats really all there is too it. You then repeat those steps for Year and Month and arrange however is sensible for your project.
3 Replies
If you have a date table, you can build one using the standard slicer.
For the Days, bring in the day number a slicer and set the slicer to be "Horizontal" instead of "Vertical". This option can be located under the "General" area of the visual options.
The only thing I don't like about the "Horizontal" setting of the slicer is that the ordering of the tiles goes top to bottom, then left to right which is awful for most users.
Click on slicer visual
Drag into the slicer "field" box the "Day Number" column from your date table.
Click on the format option for the slicer (looks like a rolling paint brush)
Open up General
Select Horizontal Orientation.
Thats really all there is too it. You then repeat those steps for Year and Month and arrange however is sensible for your project.