cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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 .

 

time.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: calendar date visual

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.


   

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

Proud to be a Datanaut!


   


3 REPLIES 3
Super User
Super User

Re: calendar date visual

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.


   

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

Proud to be a Datanaut!


   


Re: calendar date visual

hi @Ross73312

 

can you please share the steps ?

Super User
Super User

Re: calendar date visual

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.


   

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

Proud to be a Datanaut!