topic Re: Need to make these graphs filterable by both slicers SAMPLE PBIX ATTACHED in DAX Commands and Tips

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

kjohnanand — Fri, 21 Jun 2024 19:15:34 GMT

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=

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

lbendlin — Sat, 22 Jun 2024 14:57:20 GMT

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

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

kjohnanand — Mon, 24 Jun 2024 00:43:38 GMT

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=

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

kjohnanand — Mon, 24 Jun 2024 01:05:52 GMT

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=

topic Re: Need to make these graphs filterable by both slicers *SAMPLE PBIX ATTACHED* in DAX Commands and Tips

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

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

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

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

topic Re: Need to make these graphs filterable by both slicers SAMPLE PBIX ATTACHED in DAX Commands and Tips

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

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

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

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