Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I am analyzing the SLA status of the tickets. But I am experiencing inconsistency. What I want to do is to filter and list the openperiod and close period dates at the same time. I'm new to Power BI I need help
For example, here in the filter section, I am listing the sla breach tickets that were closed in week 37. I also want to add the tickets that were opened in week 37 and received sla to the list. Because some tickets may not have been closed yet, I am missing the essence due to the close date period filter. What can I do ?
Thank you,
Solved! Go to Solution.
Hi @melikekurrt ,
Please try this way:
Here is my sample data:
Use Numeric range parameter to create another table for slicer:
The minimum and maximum values here correspond to the minimum and maximum values of fxPeriod in your original data, respectively.
Then use this DAX to create a measure:
Filter =
VAR _fxPeriod = SELECTEDVALUE(fxPeriod[Parameter])
RETURN
IF(
ISFILTERED(fxPeriod[Parameter]),
IF(
MAX('Table'[fxClosedPeriod]) = _fxPeriod || MAX('Table'[fxOpenPeriod]) = _fxPeriod,
1,
0
),
1
)
Set up the filter as shown below:
Output:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @melikekurrt ,
Please try this way:
Here is my sample data:
Use Numeric range parameter to create another table for slicer:
The minimum and maximum values here correspond to the minimum and maximum values of fxPeriod in your original data, respectively.
Then use this DAX to create a measure:
Filter =
VAR _fxPeriod = SELECTEDVALUE(fxPeriod[Parameter])
RETURN
IF(
ISFILTERED(fxPeriod[Parameter]),
IF(
MAX('Table'[fxClosedPeriod]) = _fxPeriod || MAX('Table'[fxOpenPeriod]) = _fxPeriod,
1,
0
),
1
)
Set up the filter as shown below:
Output:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Does your data model have a Calendar table? Are your slicers fed by disconnected tables or from the data model?
Lutfen, provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
99 | |
38 | |
37 |
User | Count |
---|---|
158 | |
125 | |
76 | |
74 | |
63 |