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. 

zenisekd's avatar
zenisekd
Super User
6 months ago

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...

  • EugenioProlog's avatar
    EugenioProlog
    Helper III
    6 months ago

    For the M/Q/Y, I have this field parameter: 

    Granularidade = {
        ("Diário", NAMEOF(dim__calendario[dt_data]), -1), --(daily is hidden from the visual)
        ("Mensal", NAMEOF(dim__calendario[dsc_mesano]), 0),
        ("Trimestral", NAMEOF(dim__calendario[Formatted_Trimestral]), 1),
        ("Anual", NAMEOF(dim__calendario[num_ano]), 2)
    }


    For the ARR/MRR, I have a simple parameter on a created table called Seletor_MRR_ARR that has only one column, and looks like this:

    mrr_arr
    MRR
    ARR

    Then I have this metric on my dashboard: 

    _Seletor_MRR_ARR =
    SWITCH(
        SELECTEDVALUE(Seletor_MRR_ARR[mrr_arr]),
        "MRR", [MRR Acumulado],
        "ARR", [ARR Acumulado],
        BLANK()
    )



    • dk_dk's avatar
      dk_dk
      Super User
      6 months ago

      Hi EugenioProlog ,
      I have re-created your setup with some sample data, and this issue does not occur for me. (I added my .pbix so you can check that you have the same logic in your file just in case).

      So I believe something else is the issue.

      Can you check if any unexpected filters affect your visuals (the chart and the arr-mrr selector) when you select month/qu

      arter/year in your other selector? Alternatively, check if the visual works as expected if you replace the parameter with dim__calendario[Formatted_Trimestral] in the x axis. It is very strange that with the month selection it works but with the quarter it does not.