Visual filtering affecting other parameter columns

[ViktorijaJ]

Hi,

How do you add specific visual filtering based on a parameter selection so that it does not affect the visual when selecting other parameters?

[ViktorijaJ]

Hi,

Thanks for your reply.

That is testing if it is filtered. I have three text columns that have blank values in some of the rows and I am using paramaters on a visual to show the columns based on paramater slicer selection. A blanket filter will not work as it affects the different column based on a selection. As an example one of the columns might be blank and that will affect a different paramater as the filter is on the visual rather than the paramater?

[Anonymous]

Hi @ViktorijaJ 

Perhaps you could use the ISFILTERED function.

ISFILTERED function (DAX) - DAX | Microsoft Learn

I ran the testing as follows:

My sample:

Then I created a measure as follows.

Measure = IF(ISFILTERED('ID'[ID]), 1, 0)

Output:

Is this the result you expect?

If I've misunderstood you, please provide detailed sample data and the results you are hoping for: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account. So that we can better understand the problem and help you.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.