- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Matrix chart dates without affecting chart dates
Hi all - I have a matrix chart which I have restricted using a filter to show patient clinics in the next 30 days. However, I also have a chart which is based on the same data and which is showing the same data but historical as well as present and next 30 days (complete date range) .
I'd like to be able for users to click on one of the clinics in the matrix and for the chart to change but to NOT be limited to date range. At the moment, because the two are obviously linked, when I click on a clinic the chart shows only those dates in the next 30 days which makes the chart very limited in it's purpose of giving the user an idea of historical trends as well.
Is there a way of being able to click on a clinic, for the chart to show ALL dates but the matrix to stay showing just the next 30 days? The data in the matrix is useful but far too much if it shows the whole year!! Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
Please read up on "Edit Interactions". May be that helps.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Creative_tree88 it will be easier to provide a solution if you can share sample pbix file using one drive/google drive. make sure to remove sensitive information before sharing.
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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
01-23-2025 01:46 AM | |||
09-10-2024 05:16 AM | |||
09-20-2024 01:30 PM | |||
06-25-2024 09:38 AM | |||
04-03-2024 09:32 AM |