Forum Discussion

tools12345's avatar
tools12345
Icon for Helper I rankHelper I
4 years ago
Solved

How to hide a value in a row

Hello BI Community, I would like to ask for your insights, how can we be able to hide a specific value in a row for just a specific week column? Below image with top table (current) and bottom table (ideal result we want to achieve)
Tried to consider conditional formatting but it is not workable on our current case. Hope you can share some thoughts. Will greatly appreciate it. Thank you! 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Thank you for your message.

    Could you please check the below picture and the attached pbix file if it suits your requirement?

     

     

    New Measure: = 
IF (
    (
        SELECTEDVALUE ( data[Currency] ) = "Indonesian Rupiah"
            || SELECTEDVALUE ( data[Currency] ) = "CNY"
            || SELECTEDVALUE ( data[Currency] ) = "Pesos"
    )
        && SELECTEDVALUE ( data[CB - Wk] ) = "Jul - W27",
    BLANK (),
    SUM ( data[amount_balance] )
)
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi, 

    Thank you for your message.

    Please try to replace the measure with the below.

     

     

    New Measure: = 
IF (
    (
        SELECTEDVALUE ( data[Subsidiary] ) = "subsidiary a"
            || SELECTEDVALUE ( data[Subsidiary] ) = "subsidiary b"
            || SELECTEDVALUE ( data[Subsidiary] ) = "subsidiary c"
    )
        && SELECTEDVALUE ( data[CB - Wk] ) = "Jul - W27",
    "",
    SUM ( data[amount_balance] )
)

15 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Do the week columns in that matrix are values from the same column or each week is a different column?

    • tools12345's avatar
      tools12345
      Icon for Helper I rankHelper I
      4 years ago

      Hi Anonymous the week column is a different column, we would like to just hide the value of W27 but still display the succeeding weeks' value from W28, W29, and onwards. Thank you!

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    One of ways to achieve this is to write a measure something like below.

     

     

    A new measure: =
IF (
    SELECTEDVALUE ( 'Dates Table'[month-week column] ) = "Jul-W27",
    BLANK (),
    [Your initial measure]
)

     

     

    If the visualization shows TOTAL, it has to be written in a different way based on how you want to show. But for now, please try the above and please share the outcome if it works or not.

    Thanks.

    • tools12345's avatar
      tools12345
      Icon for Helper I rankHelper I
      4 years ago

      Hi Jihwan_Kim thank you so much for the insights, tried the measure suggested above but it still displays the value under W27 on the matrix table. We would like to hide the value of W27 but still display the succeeding weeks' values from W28, W29, and onwards. Any other options we can achieve that? Thank you!

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Icon for Super User rankSuper User
        4 years ago

        Hi,

        thank you for your message.

        Please share your sample pbix file's link here, and then I can try to have a look to come up with a more accurate solution.

        Thanks.