Date Slicer for Between Dates

[srinival]

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 like (Table R, Table C,  Table S) and created Date_Dim table with a calendar year.

Created a relation between the Date_Dim (One to Many Relationship to Table R, Table C and Table S).

Now when we are using slicer in Power Pivot, with Date Slicer where we pulled the date fro Date_Dim column, we are not able view the data accordingly.

We are using Card Visual to display information through measures defined.

Please help how to fix this issue.

Regards

Srini 

[amitchandak]

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]

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]

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]

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]

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]

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

[BANU]

https://1drv.ms/u/s!AiVfgZ635PWYaDXLsxDyc5LeFtw?e=Gbi0Wd 

[BANU]

Dear Dedmon Dai & Amit,

kindly address this on priority, I need to sync the data between two dates .

https://1drv.ms/u/s!AiVfgZ635PWYaDXLsxDyc5LeFtw?e=Gbi0Wd 

Regards

Husna Banu

[v-deddai1-msft]

There is something wrong with your Resolved date/time column. Would you please correct it and upload again?

[BANU]

Hello team,

I am uploading new data Just to keep it simple, Please help the date slicer is not working inspite of building a relationship.

here is the link

https://1drv.ms/u/s!AiVfgZ635PWYbyxahJd4w3PhBxI?e=917Ubv 

[v-deddai1-msft]

Hi,

How did  you create your calendar? Why your date column is the identity field, please see the difference between your calendar table and the calendar table that I created and it works well.

Best Regards,

Dedmon Dai

[BANU]

Hello ,

Those are the Null values, if you filter you'll be able to view the dates,

Basically there are multiple sheets & multiple dates, but I want relationship between only few selected dates & create a common link which is dim_Date, I tried all the option but unfortunately non of these are working out.

https://1drv.ms/u/s!AiVfgZ635PWYbhJB5jCQlYk9lg4?e=XB4apm

Appreciate your quick response

Regards

Husna Banu

[BANU]

Any luck on my query plz