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.

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.