Forum Discussion

Ashes's avatar
Ashes
Frequent Visitor
2 years ago
Solved

Icon Conditional Formatting and Calculation Groups using Field Values

I've just come across the icon conditional formatting and calculation groups. When I was trying to combine them to reduce the time needed in doing the conditional formatting on each columns I thought...
Need Help
Tips and Tricks
  • Ashes's avatar
    Ashes
    2 years ago

    Ok I think I have discovered the root cause.

    Because the underlying measure is originally of a type that is Integer, it is not adjusting to the type String that the Calculation Group is adjusting it to. And a field value source requires a measure to have a type of String.

    So if I convert the measure to output a string initially and then do the switch on that through the Calculation Group it is now selectable.

    So the problem is that the measure maintains it's original Data Type even if the Calculation Group is changing the output.

Ashes's avatar
Ashes
Frequent Visitor
2 years ago

Thanks for the vids. Unfortunately they didn't seem to address the issue I am experiencing, where I am unable to select a measure tweaked by the Calculated Group for a Field Value option for Icon Conditional Formatting, but is selectable as a Rule input to the Icon Conditional Formatting (just can't be used there because it doesn't contain values).

Effort to provide them appreciated though. 

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    Hi Ashes ,

     

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.

    • Ashes's avatar
      Ashes
      Frequent Visitor
      2 years ago

      It seems I can't share files from where I am employed. So I'll create an example of the scenario with some mockup data under my personal account later on.

    • Aklys's avatar
      Aklys
      Helper I
      2 years ago

      I'm sure I replied to this from this account. But I'll try again

       

      Example Power BI File 

      So I had a full explanation of exactly the steps but I'll just summarize this time due to time. There are two Icon Conditional Format Source Measures created. One is modified by the Calculation Group which is KPI_CF_CG, it can't seem to be used a source for a Field Value while the other more specific measure doing the switch itself works just fine. Behaviour seems to be the same if it is a natural column or a display measure that is it is applied to.

      • MFelix's avatar
        MFelix
        Super User
        2 years ago

        Hi Aklys ,

         

        I believe that you need to have this formatting to be done automatticaly based on the measure that you have so you don't do any condittional formatting in the values, since the condittional formatting is done using a different process where you can select each of the values, having this on the calculation item does not avoid you to do it manually for each measure.

         

        In this case and since your are doing just the normal icons I would do the KPI's calculation using the following way:

        VAR _CF =
    SWITCH (
        TRUE (),
        SELECTEDMEASURE () = 9000, UNICHAR(128994),-- "CircleHigh",
        SELECTEDMEASURE () = 9001, UNICHAR ( 128993 ),-- "CircleMedium",
        SELECTEDMEASURE () = 9002, UNICHAR ( 128308 ),-- "CircleLow",
        UNICHAR ( 9899 )
    )
RETURN
    IF (
        CONTAINSSTRING ( SELECTEDMEASURENAME (), "KPI*CF*CG" ),
       
         SELECTEDMEASURE() & " " &_CF,
        SELECTEDMEASURE ()
    )

         

        This will add the KPI on the measure it self.

         



    • Aklys's avatar
      Aklys
      Helper I
      2 years ago

      That's totally fine. I'm greatful for trying to assist me.

      I'm pretty sure your attempt at helping me is what assisted me in figuring it out. Sounding it out with someone always helps 🙂