Forum Discussion

bjurek's avatar
bjurek
Helper I
3 years ago
Solved

HASONEVALUE problem

in the Power BI Dekstop program, I have 4 columns that I place in the matrix visualization. I put Year column, Month column and Day column in rows and Value column in values. Would like to not show...
Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    I have exactly the same but Year, Month and Day are text type:

     

     

mlsx4's avatar
mlsx4
Memorable Member
3 years ago

But where are your rows?

 

 

bjurek's avatar
bjurek
Helper I
3 years ago

Sometimes i need colaps Month=1 and i dont want show sum of value for Month=1. Can you do it ? 

  • mlsx4's avatar
    mlsx4
    Memorable Member
    3 years ago

    If you write a "", it will keep the value visible:

     

     

    • bjurek's avatar
      bjurek
      Helper I
      3 years ago

      Columns which i grouping are: Year, Month, Day. 
      Value column is: Value
      Table with Year,Month,Day nad Value is Table_Name. 

      Maybe I make some wrong with name of columns or table. I dont know 😞 

      • mlsx4's avatar
        mlsx4
        Memorable Member
        3 years ago

        But if you do this, doesn't it work?

        sumSc = SWITCH(
    TRUE(),
    ISINSCOPE('Table'[Day]),SUM('Table'[IndeksVisible]),
    ""
)