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
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

       

       

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

        Upload it to the OneDrive for Business, and share the link.