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 ...
  • 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] )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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] )
)
tools12345's avatar
tools12345
Icon for Helper I rankHelper I
4 years ago

Thank you so much Jihwan_Kim - it works perfectly! Thanks a lot!! 🙏🏻