Forum Discussion

EugenioProlog's avatar
EugenioProlog
Helper III
6 months ago
Solved

Trouble with button segmentation behavior with 2 buttons

I have two button segmentations in my dashboard, one for chosing the time granularity (Monthly, Quarterly, Yearly) and other one to choose which metric to display (ARR or MRR). Whenever I filter one ...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    6 months ago

    Hi EugenioProlog ,

    Since both slicers are field parameters, selecting one shouldn’t clear the other. This usually occurs when the measure returns BLANK because the filter context changes as you switch granularity.

    Here are a few things to check.

    1. Does SELECTEDVALUE(Seletor_MRR_ARR[mrr_arr]) return BLANK when you select Quarterly?

    2. Turn on Edit interactions and make sure the granularity slicer isn’t filtering the ARR/MRR slicer.

    3. Try placing Formatted_Trimestral directly on the axis (without the parameter) to see if the measure still disappears.

     

    If the visual only blanks on Quarterly, it may be a context issue related to the calendar column used in that parameter.

     

    I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.

MasonMA's avatar
MasonMA
Super User
6 months ago

Are those Mensal/Trimestral buttons Bookmark navigator? If yes, you'd need to fix the bookmark so it doesn't reset ARR/MRR. In Bookmark setting disable Data and leave Display on. Bookmark only changes visuals/layout, not slicer selections. Otherwise please provide more so that other users can help diagnose. 

  • EugenioProlog's avatar
    EugenioProlog
    Helper III
    6 months ago

    They are not bookmarks; they are Field Parameters with segmentation buttons. 

    • V-yubandi-msft's avatar
      V-yubandi-msft
      Community Support
      6 months ago

      Hi EugenioProlog ,

      Since both slicers are field parameters, selecting one shouldn’t clear the other. This usually occurs when the measure returns BLANK because the filter context changes as you switch granularity.

      Here are a few things to check.

      1. Does SELECTEDVALUE(Seletor_MRR_ARR[mrr_arr]) return BLANK when you select Quarterly?

      2. Turn on Edit interactions and make sure the granularity slicer isn’t filtering the ARR/MRR slicer.

      3. Try placing Formatted_Trimestral directly on the axis (without the parameter) to see if the measure still disappears.

       

      If the visual only blanks on Quarterly, it may be a context issue related to the calendar column used in that parameter.

       

      I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.

      • EugenioProlog's avatar
        EugenioProlog
        Helper III
        6 months ago

        1. Does SELECTEDVALUE(Seletor_MRR_ARR[mrr_arr]) return BLANK when you select Quarterly?
        2. Turn on Edit interactions and make sure the granularity slicer isn’t filtering the ARR/MRR slicer.

        Answer - Yes. I created a metric 

        test measure = SELECTEDVALUE(Seletor_MRR_ARR[mrr_arr]) and it returns blank even if i disable the interactions.

        3. Try placing Formatted_Trimestral directly on the axis (without the parameter) to see if the measure still disappears.
        Answer - The measure does not disappear if I put Formatted_Trimestral directly on the axis. It displays correctly.