Forum Discussion

MrDigital's avatar
MrDigital
Frequent Visitor
6 years ago

Calculated Column: Ignore filter

Hi to all,   I created a calculated column which gives me a status if a target is reached. It basically compares the values in column "plan" with the one in the column "actual".   I use this col...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi MrDigital ,

 

Are your [plan] column and [actual] column from DAX formula?

Could you give all your DAX formulas that you created?

Could you give relevant visualization screenshots?

 

Best regards,
Lionel Chen

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

MrDigital's avatar
MrDigital
Frequent Visitor
6 years ago

Hi, 

 

thank you all for your help.

 

Since the data and file is confidential, I cannot share it. 

And sadly I don't have time to create a small pbix file with the same problem. 

 

But eventually I was able to solve my problem by using slicers instead of page / report level filter.

I sync the slicers across all pages and with "Edit interactions" I was able to disable the filtering of some visualizations. 

That is not as sleek as page filters, but it works.

I just wish that these functionality would also work for page / report filter, not only for slicers.

 

Thanks for your help!