Forum Discussion

WTAS80486's avatar
WTAS80486
Icon for Helper IV rankHelper IV
4 years ago
Solved

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      I wanted to change it to calender visual.   I...
  • WTAS80486's avatar
    WTAS80486
    4 years ago

     

    I imported this visual from  More visuals--> AppSource

     

     

daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
4 years ago

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?

  • WTAS80486's avatar
    WTAS80486
    Icon for Helper IV rankHelper IV
    4 years ago

     

    I imported this visual from  More visuals--> AppSource

     

     

  • WTAS80486's avatar
    WTAS80486
    Icon for Helper IV rankHelper IV
    4 years ago

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

     

     

    OR slicers be created 

     

     

     

    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