Card Visual

[Anonymous]

Card Visual filters: After publishing the report, applied filters don’t seem to work properly, the visual displays as-is with filters still applied. This normally happens after the report is published & is refreshed either through a schedule or manually from dateset, my applied card visual filters have values "True" or "False", upon my investigation I noticed new filter values: "-1" & "0" instead of "True" or "False" and that is the reason why the originally applied filters don’t work anymore then I was forced to reapply the filters on the cloud for the same report and this time around my new filter values are “-1” or “0” instead of “True” or “False”. Is there specific reason why this is happening?

[pranit828 · Accepted solution]

HI @MatlolHG

This might be because of the data present in that column or measure whihc is an invalid True/False.

I always use 1 and 0 for that case and create a function to display true for 1 and false for 0

IF([COL]=1,"True","False")

[v-yiruan-msft]

Hi @Anonymous ,

Could you please provide the field or mesure which applied on card visual and its formula in order to make troubleshooting? Besides that, please provide the screen shot about the setting of Filter pane.Thank you. 

Best Regards

Rena

[Anonymous]

Hi @yingyinr

Although I marked the problem "resolved" I still have this question, why is the card visual converting text values to numeric values

1. Data attributes values

2. Applied filters before publishing the report to the cloud

3. Filter values after publishing the report

Point 3) above demonstrate why the applied filters were not effective after publishing the report to the cloud

[pranit828]

Hi @Anonymous 

Can you please check if you have the data type as below. IF not please change and retry

[Anonymous]

Hi @pranit828

Thanks for the response, I get visual error when changing data type to "True/False" Error: The function count cannot work with values type boolean

[pranit828 · Accepted solution]

HI @MatlolHG

This might be because of the data present in that column or measure whihc is an invalid True/False.

I always use 1 and 0 for that case and create a function to display true for 1 and false for 0

IF([COL]=1,"True","False")

[Anonymous · Accepted solution]

Hello @pranit828

Sorry for the delay in response

As you advised,

I added a new conditional column to change the desktop attribute values from "True" or "False" to "0" or "-1" and reised the report.

Power Query Used: Table.AddColumn(-"Filtered Rows", "ColumnName", each if [ColumnName] á true then 0 else if [ColumnName] á false then -1 else null)

[amitchandak]

@Anonymous , Typically these republish error goes away with clear cache and refresh. Check that out, if this can work for you.

[Anonymous]

Hi amitchandak 
Can you please elaborate a little bit, remeber this reports is published to the cloud and it's scheduled to automatically refreshes, once it's refreshed applied filters ffrom the desktop doesn't work anymore because the original filter values changes to either "-1" or "0", if I have to clear the cache, where do I do that on the published report?