cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Robinho
Regular Visitor

Slicer with date

Hello,

 

I would like to ask a question. I have a problem when I'm using a slicer with the date it is showing all months and in the table, I have only three months.

Robinho_0-1632226586506.pngRobinho_1-1632226610590.png

I would like to have in slicer only months which are in the table not all of them. 

 

Thank you for your help. 

1 ACCEPTED SOLUTION

Hi  @Robinho ,

 

Because you are using "time intelligence",it will automatically create a hidden date table,details is as shown below:

vkellymsft_0-1632468598181.png

One way to solve this problem is to create 2 calculated columns as below:

Year = YEAR('Table'[Date])
Month = FORMAT('Table'[Date],"MMMM")

Then put the 2 columns in the fields of slicer, and you will see:

vkellymsft_1-1632468792226.png

You could check my sample attached.

 

Best Regards,
Kelly

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

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Robinho , Try to restrict by measure

Create a measure

countrows(Table)

 

Anc in visual level filter check this is not blank

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

Hello @amitchandak ,

 

I tried it not sure if correct but I don't think so if it is working.

Please can you send here the procedure on how to do it?

 

Thank you very much.

Hi  @Robinho ,

 

Because you are using "time intelligence",it will automatically create a hidden date table,details is as shown below:

vkellymsft_0-1632468598181.png

One way to solve this problem is to create 2 calculated columns as below:

Year = YEAR('Table'[Date])
Month = FORMAT('Table'[Date],"MMMM")

Then put the 2 columns in the fields of slicer, and you will see:

vkellymsft_1-1632468792226.png

You could check my sample attached.

 

Best Regards,
Kelly

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

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!