Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 publishe...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
    Anonymous
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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)