Forum Discussion

AK1234's avatar
AK1234
Frequent Visitor
5 years ago
Solved

Is it possible to create custom matrix?

Hi, 

 

I was wondering if it is possible to create the below in powerbi? I am trying to create a dashboard that shows the performance of our data warehouse  and it needs to be able to tell us whether each DB was successful or failed using icons. I am also trying to make sure it expands so we can see further info. 

 

I started to do it in a matrix but struggled to condtional format by row to ensure each DB has its own conditions 

 

Does anyone know of any way to do it or if there is a thread anywhere i can look at?

Need Help
  • D4imi0n's avatar
    D4imi0n
    5 years ago

    Hi AK1234,

    this should work. 

     

    I inserted a Matrix with two new Measures:

    Measures:

    Status = 
VAR __char = IF(SUM(Forum[uoa_bl]) > 0.04,UNICHAR(9899),UNICHAR(11035))
RETURN __char
    Status_Switch = 
VAR __char = SWITCH(VALUES(Forum[Line]),"A1",UNICHAR(11035),"A2",UNICHAR(9899),UNICHAR(9670))
RETURN __char

     

    Hopefully this helps. 

     

    Cheers Jeffrey

2 Replies

  • D4imi0n's avatar
    D4imi0n
    Icon for Helper I rankHelper I
    5 years ago

    Hi AK1234,

    this should work. 

     

    I inserted a Matrix with two new Measures:

    Measures:

    Status = 
VAR __char = IF(SUM(Forum[uoa_bl]) > 0.04,UNICHAR(9899),UNICHAR(11035))
RETURN __char
    Status_Switch = 
VAR __char = SWITCH(VALUES(Forum[Line]),"A1",UNICHAR(11035),"A2",UNICHAR(9899),UNICHAR(9670))
RETURN __char

     

    Hopefully this helps. 

     

    Cheers Jeffrey