Forum Discussion

bjurek's avatar
bjurek
Icon for Helper I rankHelper 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:

     

     

bjurek's avatar
bjurek
Icon for Helper I rankHelper I
3 years ago

it is not working 😞

 

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

But where are your rows?

 

 

  • bjurek's avatar
    bjurek
    Icon for Helper I rankHelper 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
      Icon for Memorable Member rankMemorable Member
      3 years ago

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

       

       

      • bjurek's avatar
        bjurek
        Icon for Helper I rankHelper 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 😞