Issue with Matrix visual and Conditional Formating (Icons)

[juanalvarado08]

Hi,  

I am having an issue with PBIDesktop with the Conditional Formating applied to the Matrix visual. 

When I try to apply the Conditional Formating for Icon type, the data type of validation compares Number vs Percentage as shown in the image above, and it doesnt allow me to change either of them. The data i am trying to use are Number (Whole Number), is this a known bug?

Regards!  

[juanalvarado08 · Accepted solution]

Hi everyone!,

   First, I wanted to thank you all for the replies. The issue is weird, because I change the type of icons and it changes everything to numbers (which solved my issue), but I still can't change to percentage (i don't need to). I tried to upload a video but I dont have permission to do it. 

  I guess is because the data is in Number. I appretiate your help!! 

 This is my version.

[negi007]

@juanalvarado08  can you share your conditinal formating condition. Will then suggest solution accordinlgy. 

Alternatively, you can refer to below link for solution

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

[amitchandak]

@juanalvarado08 , you should be able to change the first and last number as a percent . All should be % or number

[Pragati11]

Hi @juanalvarado08 ,

I can't this happening at my end.

When I click on the dropdown against PERCENT, it gives me optio to choose NUMBER.

Can you add more details like what version of Power BI you are using?

Thanks,

Pragati