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

    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

    MatlolHG_0-1597926219800.png

    2. Applied filters before publishing the report to the cloud

    MatlolHG_2-1597926317784.png

    3. Filter values after publishing the report

    MatlolHG_3-1597926448656.png

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