Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

POWER BI MATRIX

Hello  If there a table like code p_no` name num area sa 1 a 1 a sa 1 b 2 b sa 1 c 3 a sa 1 d 4 a sa 1 e 5 b sa 1 f 6 a sa 1 g 7 b sa 1 ...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi BIswajit_Das ,

    Sorry for being late, please change the DAX into this:

    Measure = var _tab=SUMMARIZE(ALLSELECTED('Sheet18'[RES]),'Sheet18'[RES], "@sumvalue",CALCULATE(COUNT(Sheet18[NUM])))
var _max= maxx( _tab,[@sumvalue])
var _area=SELECTEDVALUE('Sheet18'[RES])
return  SWITCH(TRUE(),COUNT('Sheet18'[NUM])=_max&&_area="a","Blue", COUNT('Sheet18'[NUM])=_max&&_area= "b","Black",COUNT(Sheet18[NUM])=_max&&_area="c","Yellow")

    The final output is below:

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

BIswajit_Das , If you want on Area- a, b, c then you need to use a measure given below in conditional formatting using the field value option

 

Switch(Max(Table[Area]) ,

"a", "Blue",

"b", "black",

"c", "Yellow",

// add other 

"green"

)

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

  • BIswajit_Das's avatar
    BIswajit_Das
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    Hello amitchandak thanks for responding.
    But If possible can you give an example regarding this query
    i. e How to add color formating on a matrix based on the above senario.
    Thanks & Regards...

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi BIswajit_Das ,

      Please refer to the steps:
      I create a measure by using this DAX:

      Measure 2 = var _tab=SUMMARIZE(ALLSELECTED('Table (2)'[area]),'Table (2)'[area], "@sumvalue",CALCULATE(SUM('Table (2)'[value])))
var _max= maxx( _tab,[@sumvalue])
var _area=SELECTEDVALUE('Table (2)'[area])
return  SWITCH(TRUE(),sum('Table (2)'[Value])=_max&&_area="a","Blue", sum('Table (2)'[Value])=_max&&_area= "b","Black",sum('Table (2)'[Value])=_max&&_area="c","Yellow")



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

      • BIswajit_Das's avatar
        BIswajit_Das
        Icon for Impactful Individual rankImpactful Individual
        2 years ago

        HelloAnonymous 
        Thanks for responding but can you edit the measure for this data
        PCNONUMRES

        11A
        12A
        13B
        14A
        25B
        26C
        27A
        28B
        39C
        310A
        311C
        312C

        here the measure is like 

        i.e
        In rows - pcno

        columns - res

        values - count(num)
        Thanks & regards..