Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Representing measure in table

Hi there,

 

Here is a picture that I want to create in power BI:

 

Now I got a table, which already contains column that has value H1,H2,.....H5 and a column that contains C1,C2,C3,C4. In the matrix, its simple count of H and C values and categorised into different categories such as "Almost Insignificant", "Almost Minor" etc. I am thinking to create measure for each type of categories. However, I am not how should I show measures in the same format as shown in the picutre. 

 

I am not sure whether my approach is right or not. Could anyone help me how can I represent my calculated measures into the same was as shown in the picture

 

Sample file can be download from here

Need Help
Show and Tell
Tips and Tricks
  • Icey's avatar
    Icey
    5 years ago

    Hi Dunner2020 ,

     

    For color formatting, you can try to create a measure and use it in conditional formatting like so:

     

    Conditional formatting Measure =
VAR H_ =
    SELECTEDVALUE ( 'sde support_structure_evw'[AHI Score] )
VAR C_ =
    SELECTEDVALUE ( 'sde support_structure_evw'[Criticality zone] )
RETURN
    SWITCH (
        TRUE (),
        H_ = "H1"
            && C_ = "C1", "light blue",
        H_ = "H2"
            && C_ IN { "C1", "C2" }, "deepskyblue",
        H_ = "H3"
            && C_ IN { "C1", "C2", "C3" }, "dodgerblue",
        H_ = "H4"
            && C_ IN { "C1", "C2", "C3", "C4" }, "blue",
        "green"
    )

     

    Reference: Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

     

     

     

    Best Regards,

    Icey

     

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

6 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Dunner2020  

     

    Please see attached file (below signature) - you can set this up as Matrix visual. I would recommend created calculated columns in Power Query - so click Transform Data, then Add Column > Conditional Column. 

     

    If criticality zone = C1 then ..... and enter the info you need to get the correct column headings. 

     

    Repeat Add Column > Conditional Column for the H numbers as well. Then use these new columns in your matrix visual in place of the AHI and criticality zones. 

     

    Do you need help with the color formatting too?

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Dunner2020 ,

         

        For color formatting, you can try to create a measure and use it in conditional formatting like so:

         

        Conditional formatting Measure =
VAR H_ =
    SELECTEDVALUE ( 'sde support_structure_evw'[AHI Score] )
VAR C_ =
    SELECTEDVALUE ( 'sde support_structure_evw'[Criticality zone] )
RETURN
    SWITCH (
        TRUE (),
        H_ = "H1"
            && C_ = "C1", "light blue",
        H_ = "H2"
            && C_ IN { "C1", "C2" }, "deepskyblue",
        H_ = "H3"
            && C_ IN { "C1", "C2", "C3" }, "dodgerblue",
        H_ = "H4"
            && C_ IN { "C1", "C2", "C3", "C4" }, "blue",
        "green"
    )

         

        Reference: Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

         

         

         

        Best Regards,

        Icey

         

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

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi again Dunner2020 

     

    Can you please share a sample of what the data table looks like that you have to work with? We can't really help without knowing what that looks like and I'm a visual person, so I know you tried to desribe but in this case a table is worth a thousand words. 🙂 

     

    Thanks!