Forum Discussion

Amyrie_m's avatar
Amyrie_m
Regular Visitor
1 year ago
Solved

Show/ Hide Date slicer

Hello everyone!

I have a dropdown list called Date Range (left side) I'm looking for a way to show or hide the date_range (right side).

For example, If I select "Sunset time", the orange date_range is not displayed. Otherwise, if I select "Night time", the black date_range is not displayed. Is there a way to achieve this? Thank you!

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Amyrie_m , hello PijushRoy, thank you for your prompt reply!

    As far as I know, there is no property that directly control the visibility of visuals.

     

    As a workaroud, we can create measures that format the button Text colour to a transparent #FFFFFF00 to indirectly hide it.

    Make Transparent = 
IF(
      
         SELECTEDVALUE('SpecialDates'[Period])="Sunset time",
         "#FFFFFF00", -- returns transparent if condition is True
         "orange")
         
      
    Make Transparent2 = 
         IF(
         SELECTEDVALUE('SpecialDates'[Period])="Night time",
          "#FFFFFF00", -- returns transparent if condition is True
         "blank")

    Then use the relevant measures to format the style of visuals:

    Result for your reference:

     

     

     

     

    Best regards,

    Joyce

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    1 year ago

    Hi Amyrie_m 

    Can you please share more details about the right-side function? how it is working.
    If you share a sample PBIX file link (google drive/noteone/sharepoint/box), it will be super helpful to analyze to provide a solution quickly

    • Amyrie_m's avatar
      Amyrie_m
      Regular Visitor
      1 year ago

      Thanks for your response! Here is my pbix file, please take your time to consider it.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Amyrie_m , hello PijushRoy, thank you for your prompt reply!

        As far as I know, there is no property that directly control the visibility of visuals.

         

        As a workaroud, we can create measures that format the button Text colour to a transparent #FFFFFF00 to indirectly hide it.

        Make Transparent = 
IF(
      
         SELECTEDVALUE('SpecialDates'[Period])="Sunset time",
         "#FFFFFF00", -- returns transparent if condition is True
         "orange")
         
      
        Make Transparent2 = 
         IF(
         SELECTEDVALUE('SpecialDates'[Period])="Night time",
          "#FFFFFF00", -- returns transparent if condition is True
         "blank")

        Then use the relevant measures to format the style of visuals:

        Result for your reference:

         

         

         

         

        Best regards,

        Joyce

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.