Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

CONVERT TO % THE RESULT OF A SINGLE CARD VISUALISATION

I want to please convert to % the result of a single number card. Can you please help me do this?

 

 

 

  • Don't select the field with check box, click on the field name 

10 Replies

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion

    Can you please explain a bit more, also share some sample data and desired output that you are looking for.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I have a list of incidents by group (N1,N2,N3) and my card displays only the number of incidents of the group N1. I would like to convert that result (number of incidents of the group N1) in %.

      • FarhanAhmed's avatar
        FarhanAhmed
        Community Champion
        Percent Status = COUNT('Table'[ID])/CALCULATE(COUNT('Table'[ID]),ALL('Table'))
    • Anonymous's avatar
      Anonymous
      Not applicable

      i can't see this function in my view power bi

       

       

      • ponnusamy's avatar
        ponnusamy
        Solution Supplier

        You need to click the data field you need to format