Forum Discussion
Card Visual
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)
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?