Forum Discussion
Advocate IMeasure filter for a table based on 2 slicers
The amount of data that I have in my report and then with that the visuals to then change to make it anonymous data and the time this would take I did a little more research and found using a parameter I could swith between the 2 date options I wanted to filter on and that worked for been able to toggle between the 2 options of which date to filter on. I am still struggling with been able to filter by either of the dates, but for now it should be "good enough"
PLHM - OK this information indicates you are trying to slice with two date columns from the same table. In which case it's no wonder your measures are returning blank. Your date filtering is counteracting each other and reducing the rows to 0.
As well as the parameter I would suggest implementing one or more date tables from which you can remove / change filter context in different situations. This can be achieved via DAX code or a parameter as you say.
If you implement one date table for both columns, make sure the relationships are in-active and you use USERELATIONSHIP inside CALCULATE measures to activate the relationships when necessary.
v-kpoloju-msft - if you are looking to close this one off as solved, I suggest we do so with this response. It is the best we can do in this situation.
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
Community SupportHi PLHM,
Thank you for reaching out to the Microsoft fabric community forum.
Please 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.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Thank you.
Community SupportHi PLHM,
We haven’t received a response with the requested sample data to help troubleshoot your issue effectively.
To proceed further, please share a minimal and clean sample dataset (not a screenshot) along with the expected output. This helps the community understand and resolve your question faster.
Thank you.
- v-kpoloju-msft
Hi PLHM,
Following up again as we still haven't received the required sample data or clarification to assist with your issue. Please provide relevant sample data based on your thread.
Thank you.
PLHMThe amount of data that I have in my report and then with that the visuals to then change to make it anonymous data and the time this would take I did a little more research and found using a parameter I could swith between the 2 date options I wanted to filter on and that worked for been able to toggle between the 2 options of which date to filter on. I am still struggling with been able to filter by either of the dates, but for now it should be "good enough"
- mark_endicott
Super User
PLHM - OK this information indicates you are trying to slice with two date columns from the same table. In which case it's no wonder your measures are returning blank. Your date filtering is counteracting each other and reducing the rows to 0.
As well as the parameter I would suggest implementing one or more date tables from which you can remove / change filter context in different situations. This can be achieved via DAX code or a parameter as you say.
If you implement one date table for both columns, make sure the relationships are in-active and you use USERELATIONSHIP inside CALCULATE measures to activate the relationships when necessary.
v-kpoloju-msft - if you are looking to close this one off as solved, I suggest we do so with this response. It is the best we can do in this situation.
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!