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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
arjun123
Regular Visitor

Date slicer problem

I created a date slicer  in my report. The problem is it's filtering only one measure net revenue. 

None of the other values are filtering by date.

What is the issue here??Capture.PNG

1 ACCEPTED SOLUTION

It seems like the relationship you have is autodetected by Power BI itself. Please edit that relationship because you have a circular relationship which makes dim_date and customer_lookup having inactive relationship.

View solution in original post

3 REPLIES 3
parry2k
Super User
Super User

@arjun123 you have to share your data model, and revenue measure you are using in card visual otherwise no one is going to find out what is going on.

 

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Capture2.PNGCapture3.PNG

It seems like the relationship you have is autodetected by Power BI itself. Please edit that relationship because you have a circular relationship which makes dim_date and customer_lookup having inactive relationship.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.