- 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
Override the dashboard filter and assign it to another column
Hi Buddy,
I am trying to figure out the DAX query to override a the dashboard filter and assign it to another column
This is my dataset
id | openDate | closeDate | Status |
1 | 2/1/2024 | Open | |
2 | 2/2/2024 | Open | |
3 | 2/3/2024 | Open | |
4 | 2/1/2024 | Open | |
5 | 2/2/2024 | Open | |
6 | 2/1/2024 | 2/2/2024 | Close |
7 | 2/2/2024 | 2/3/2024 | Close |
My dashbord have a filter, it is based on the openDate, user can multiple select the date they want
What I need to do is to form a chart like this
My solution
1. create an additional field reportDate which based on both openDate / closeDate
2. overide the original DashboardFilter
3. assign the filter to the field reportDate
(I can't make it to work )
This chart work fine if no filter was applied.
If select 2/2, the expected behavious is showing 2 for open and 1 for close
but now look like my DAX query get some problem
pbix file link
https://drive.google.com/file/d/16XS7Gmjy-Wx167-Iq1BUCGsXRjVD55xy/view?usp=sharing
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Consider utilizing USERELATIONSHIP between your calendar table and the two dates in your fact table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Consider utilizing USERELATIONSHIP between your calendar table and the two dates in your fact table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Relationship active / non-active may work, it is a model change I am trying to avoid.
I am thinking if it is possible to do it from DAX side.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
TREATAS is another option
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!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
06-29-2024 06:35 AM | |||
05-22-2024 11:36 AM | |||
10-05-2023 03:54 AM | |||
06-05-2024 08:15 AM | |||
07-10-2024 08:53 AM |
User | Count |
---|---|
21 | |
17 | |
12 | |
6 | |
5 |
User | Count |
---|---|
29 | |
25 | |
20 | |
13 | |
10 |