Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
WTAS80486
Helper IV
Helper IV

Calendar visual or two date slicer for data parameters created using direct query

I am trying to create calendar visual or two date slicers for date parameter.

 

Right now I have it in form of list using slicer visual

 

Ankita80486_0-1660775841200.png

 

 I wanted to change it to calender visual.

 

I have created ReadingStartDate and EndDateTables using direct query 

 

Ankita80486_1-1660775841201.png

 

That means I cannot make any changes to these tables in Power query

 

Ankita80486_2-1660775841201.png

 

 

Ankita80486_3-1660775841202.png

 

 And then bind parameters to them 

 

Ankita80486_4-1660775841202.png

 

Ankita80486_5-1660775841202.png

 

 

Can Calendar visual be displayed instead of dropdown on report page?  using direct queries.

 

OR can slicers be created

 

Ankita80486_6-1660775841203.png

 

 

In this I need to disable after in 1st slicer and before in 2nd slicer but cannot see after or before option in dropdown for slicer , might be because it’s a direct query and not import query

 

Ankita80486_7-1660775893692.png

 

 

1 ACCEPTED SOLUTION

Ankita80486_3-1660776412505.png

 

I imported this visual from  More visuals--> AppSource

 

Ankita80486_4-1660776492353.png

 

View solution in original post

3 REPLIES 3
daXtreme
Solution Sage
Solution Sage

Hi there.

 

If there is a calendar visual (I don't think it comes as standard with PBI), then I can't see a reason why DQ woludn't allow you to pull data out of a SQL table to populate it... After all, it's just a visual. Have you tried it yet?

Ankita80486_3-1660776412505.png

 

I imported this visual from  More visuals--> AppSource

 

Ankita80486_4-1660776492353.png

 

As soon as i change it to calender visual i see this

 

Ankita80486_0-1660776190204.png

 

OR slicers be created 

 

Ankita80486_1-1660776239723.png

 

 

In this I need to disable after in 1st slicer and before in 2nd slicer because i need two dates(readingstartdate and readingenddate)

but cannot see after or before option in dropdown for slicer , might be because it’s a direct query and not import

 

Ankita80486_2-1660776239726.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors