Forum Discussion
Card Visual
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?
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")
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)
8 Replies
Anonymous , Typically these republish error goes away with clear cache and refresh. Check that out, if this can work for you.
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?
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
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")
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
