Forum Discussion

cody_c's avatar
cody_c
New Member
8 months ago
Solved

Slicer Options for Datetime Format Parameter

I am building a report that uses three parameters for a SQL view in Direct Query mode: Start Date, End Date, and Site ID. The end goal is to allow the end user to select all three parameters to view ...
Need Help
Tips and Tricks
  • Irwan's avatar
    Irwan
    8 months ago

    hello cody_c 

     

    i am not sure how your data looks like.

    in my experience, since this is direct query, i did couple workaround to achieve the requirement.

     

    here is an example..

    1. 3fff... something is a direct query table.

    2. then i summarize that direct query table. as you can see, the date is in datetime format.

    3. then i created calculated column to simplify the datetime format into date format

    4. create a relationship between those two table

    5. plot into visual with summarize table as date slicer

     

    i am not sure if this is a composite model, but here is what i did with direct query table and need to do a little change.

     

    Hope this will help.

    Thank you.

v-venuppu's avatar
v-venuppu
Community Support
8 months ago

Hi cody_c ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Irwan nielsvdc for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.