Forum Discussion
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 of them, the other one is erased.
State 1: default setup:
State 2: I click on Quarterly (Trimestral), then then ARR/MRR button goes blank, and my data disappears on the visual.
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.
12 Replies
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.
They are not bookmarks; they are Field Parameters with segmentation buttons.
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.
Hi EugenioProlog
Are these buttons with a bookmark action? Or button slicers?They are not bookmarks; they are Field Parameters with segmentation buttons.
Hi EugenioProlog are you using bookmarks for navigation or field parameters?
They are not bookmarks; they are Field Parameters with segmentation buttons.
Could you explain closer the modeling behind it? I am guessing you have one column, which is supposed to return the information on M/Q/Y for the filed parameter and then another field parameter, which switches 2 measures?
However this way it should work fine... as long as the M/Q/Y is done correctly...
UPDATE: I just deleted and recreated the MRR/ARR parameter, and everything works great now. I have no idea what was wrong but it is fixed. Thank you very much for the answers!!
