Forum Discussion
Remove blanks from Parameter Fields
Hello ,
I have Paramter:
Create a table with a single column that will act as a toggle for the filter:
FilterToggle = DATATABLE(
"Filter", STRING,
{
{"On"},
{"Off"}
}
)Create a measure that checks the value of the parameter and applies the filter conditionally:
ApplyFilter =
IF(
SELECTEDVALUE(FilterToggle[Filter]) = "On",
IF(
NOT(
ISBLANK('Incident Input'[Incident Type]) ||
ISBLANK('Incident Input'[Incident Year]) ||
ISBLANK('Incident Input'[Law Enforcement Agency])
),
1,
0
),
1
)Add a slicer to your report using the FilterToggle table.
Drag the ApplyFilter measure to the Filters pane of your visual.
Set the filter to show only values where ApplyFilter is 1.
7 Replies
Create a table with a single column that will act as a toggle for the filter:
FilterToggle = DATATABLE(
"Filter", STRING,
{
{"On"},
{"Off"}
}
)Create a measure that checks the value of the parameter and applies the filter conditionally:
ApplyFilter =
IF(
SELECTEDVALUE(FilterToggle[Filter]) = "On",
IF(
NOT(
ISBLANK('Incident Input'[Incident Type]) ||
ISBLANK('Incident Input'[Incident Year]) ||
ISBLANK('Incident Input'[Law Enforcement Agency])
),
1,
0
),
1
)Add a slicer to your report using the FilterToggle table.
Drag the ApplyFilter measure to the Filters pane of your visual.
Set the filter to show only values where ApplyFilter is 1.Hello, I have below error: A single value for column 'Subject State' in table '* Subject State' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Ania26 , Try using
DAX
ApplyFilter =
IF(
SELECTEDVALUE(FilterToggle[Filter]) = "On",
IF(
NOT(
ISBLANK(MIN('Incident Input'[Incident Type])) ||
ISBLANK(MIN('Incident Input'[Incident Year])) ||
ISBLANK(MIN('Incident Input'[Law Enforcement Agency]))
),
1,
0
),
1
)
Hello, this works but when I want to show it by year then it filters data icorrectly :
OFF:ON:
Hi Ania26 ,
Apologies for the inconvenience you're facing.
To assist you more effectively, we kindly request that you share sample data that fully represents your issue or question in a usable format (e.g., Excel or CSV), rather than 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.
How to provide sample data in the Power BI Forum - Microsoft Fabric CommunityHi Ania26 ,
We haven’t heard back from you regarding the issue mentioned above. To investigate further and provide an accurate resolution, could you please share sample data or details of the scenario? This will help us analyze the problem more effectively and get back to you with the results.
Thank You !!
