Forum Discussion

jasemilly's avatar
jasemilly
Icon for Helper III rankHelper III
6 years ago
Solved

table visual add icons conditional format

Hi   I have a table visual that shows tasks and if they have been completed, in power query I have converted from True/false to 1/0 and would like to display the Icons green/red circle. I have d...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi jasemilly 

    I think you may show your problem in your first screenshot. Is your issue that you can't apply to show the icon in conditional format?

    I build a sample to have a test.

    Origanal Table:

    After Transform(converted from True/false to 1/0 )

    Build a table visual and show icon by conditional format.

    It works well and my Power BI Version is Sep 2020(2.85.985.0 64-bit) as well, I think you may need to select fields  and use sum.

    For more info you may refer to this blog: Use conditional formatting in tables

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi jasemilly 

I think you may show your problem in your first screenshot. Is your issue that you can't apply to show the icon in conditional format?

I build a sample to have a test.

Origanal Table:

After Transform(converted from True/false to 1/0 )

Build a table visual and show icon by conditional format.

It works well and my Power BI Version is Sep 2020(2.85.985.0 64-bit) as well, I think you may need to select fields  and use sum.

For more info you may refer to this blog: Use conditional formatting in tables

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.