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] )
)
tools12345's avatar
tools12345
Icon for Helper I rankHelper I
4 years ago

Hi Jihwan_Kim it works perfect!! One last thing, how can I add the other currencies to make it blank as well to the measure? Apologies, still new in learning PBI. Thank you!! 

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, Sir Jihwan_Kim!! Works perfectly! 🙌🏻 You're a blessing! Thank you again! 🙇🏻‍♀️🙏🏻

  • 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!! 🙏🏻

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

    Hi, Sir Jihwan_Kim hope you're well! I hope I can make a follow-up inquiry to ask for your help regarding: the first measure provided above. Is there any way we can update it? I have reattached sample test file link here for further checking. t

    Below measure I have applied and it totally remove the W27 column instead of just hiding the values for each subsidiary. 

    Appreciate your further insights. Thank you! 

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

     

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

    Hi,

    I am not sure how your expected outcome looks like, but I think your measure hides everything on W28. Because there are only subsidiary a, b, and c. 

    Could you please let me know how is your expected outcome looks like?

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

    Hi Sir Jihwan_Kim, the output we are expecting is just to hide the values of each subsidiary under W27 but still be able to display the column header W27. The above measure hides everything under W27 and just display the W28 directly. Hope the below image helps. Thank you!