Forum Discussion

srinival's avatar
srinival
Icon for Helper I rankHelper I
6 years ago

Date Slicer for Between Dates

Hi All,   I am having a senario where my tables have multiple date columns and wanted to show data from Multiple tables on Report Screen with multiple visualizations.   I have a Data Modeling lik...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

The configuration seems fine. Just make sure dates do not have timestamp. If it has time stamp then create a date column and join with it (TIme other than 12:00 AM)

 

Date = [Timestamp].date

 

Also check you date covers all dates from MIN to Max of all tables.

 

Can you let us know about exact issue.

Can you share sample data and sample output.

srinival's avatar
srinival
Icon for Helper I rankHelper I
6 years ago

Hi Amit,

 

Thanks in advance.

 

As this data belongs to my organization and bit sensitive, I will not be able to share this information.

 

I have marked the Dim_date Table to Date field to Date Data type as suggested by you, still I was not able view the visualizations data getting refreshed based on the dates..

 

The data source is an Excel file, which comes out from out ticketing software. We have imported each of these sheets into Power Bi.

 

We have created a Data Modeling based on the relations to pull the Data.

 

We want to filter the data based on the Dates Choosen in the Date filter(Slicer), where the soruce for date is Dim_Date Table which was manually created by us.

 

We have few measures created which will display the numbers in the Card Visualization, and these numbers perfectly work well if we are filtering based on the catagory as Manager Slicer / Group Slicer.

 

But when we use Date slicer and select the dates between an interval the the Card visualization turn Blank, we know we have data for that period.

 

Regards

Srini

  • BANU's avatar
    BANU
    Icon for Helper I rankHelper I
    6 years ago

    Hi Amit , 

     

    Have removed all the unwanted data & kept only Date , but

     

    How to I upload the PBIX file here ? I don't see any option

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi BANU ,

       

      Would you please inform us more detailed information( your sample data(by OneDrive for Business)) if possible? Then we will help you more correctly.

       

      Please do mask sensitive data before uploading.

       

      Thanks for your understanding and support.

       

      Best Regards,

      Dedmon Dai

      • BANU's avatar
        BANU
        Icon for Helper I rankHelper I
        6 years ago

        Hello,

         

        How do I share the sample data in this forum please ?

         

        As I am not getting option to upload the pbix file