Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Date slicer not filtering several visuals

Hi.

 

I have a date lookup table with a relationship to several tables. I'm using a date slicer (date column from the date lookup table), synced with all the pages. The cardinality between the lookup table and the connected tables are all 1 to many. However, a few visuals went blank/empty (cards display blank, other visuals are just empty) when I created the relationship. Which is weird because a couple other tables work fine and the slicer properly filters. I checked everything from the interactions between the slicer and visuals to the format and type of the date columns, everything is proper. Removing the relationship between the lookup and some of the tables makes the visuals appear again. So I'm guessing it's a relationship issue but I'm not sure what the problem could be. I created the date lookup using the CALENDAR DAX function. The date ranges are very similar in the tables that are working and the ones that aren't. There are also no relationships between the other tables. 

 

Any help would be appreciated. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hello. Sorry for not providing examples but my issue was resolved. It was a data type issue; I did not use Power Query to update the data types (from date/timezone to date) of the date columns in a few tables, I only used the Data tab on the left. I'm new to Power BI so I wasn't aware I had to change them in Power Query first.

 

Thanks.

View solution in original post

4 REPLIES 4
v-xulin-mstf
Community Support
Community Support

Hi @Anonymous

 

Could you provide sample data and expected output after removing sensitive data?
Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hello. Sorry for not providing examples but my issue was resolved. It was a data type issue; I did not use Power Query to update the data types (from date/timezone to date) of the date columns in a few tables, I only used the Data tab on the left. I'm new to Power BI so I wasn't aware I had to change them in Power Query first.

 

Thanks.

Hi @Anonymous,

 

Okay, if the issue has been solved, please adopt the solution to help others.

😉

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

HotChilli
Super User
Super User

This will be solved by investigating the model, the relationships between tables and what fields and aggregations/measures are in the visuals.  Yes this is a very broad response but it's not possible to solve without seeing these things.

For a guess, I'll say there's a lookupvalue involved and when the relationship is created it filters out related values in a visual and appears 'broken'.

 

Can you provide a sample pbix for more investigation?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.