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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kjohnanand
Helper I
Helper I

Need to make these graphs filterable by both slicers *SAMPLE PBIX ATTACHED*

Hello everyone. I'm working on a project where I need to show trennding revenue for active clients by quarter. For example, if Q1 2022 had 2000 active clients and I selected that quarter in my slicer, I want a revenue trending graph that shows revenue for those 2000 clients between 2020-2024, regardless of whether they deconverted later.

 

I'm attempting to do this using a disconnected date table, and I can get it to work, but when it does, another slicer in my report breaks and no longer functions.

 

I've attached a sample PBIX that contains relevant data. In that pbix, both slicers should work to filter the graph, but I can only get one to work at a time. Any help on this would be much appreciated.

 

https://upload.disroot.org/r/JBjAgytN#dDNJTdfJ+BUTtcwGn46l0iSRVXZTk+jMfdFwoKCm67s=

3 REPLIES 3
lbendlin
Super User
Super User

Your sample file is too big and too complex. Do not include sensitive information or anything not related to the issue or question.

 

Something interesting I noticed - looks like selecting certain specific quarters (such as Q2 2020 and Q1 2021) filter down the table properly, but this doesn't apply to all the quarter selections. Any thoughts on why this would happen?

 

https://upload.disroot.org/r/jswn3G8Q#Q5s3vKWswoYJb39SZEnOcWgJTiSQxSmehrulLtspQ3k=

Hi, sorry about the file size. I removed a lot of the tables and simplified a bit to make it easier. What I need to do is make both slicers in the file filter the trending graph. The issue is with my core cohorts measure, I believe. 

 

https://upload.disroot.org/r/udRJJr33#oxSJasRdnrZyYmawlqIsGZb8Y9z+rzmP1t0HYSFr1fM=

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors