Forum Discussion

JothiG's avatar
JothiG
Icon for Helper III rankHelper III
1 year ago
Solved

Dax -tooltip screen not slicer filter value

I have synced slicers between main visual and tooltip visual. but sync not working for tooltip visual . below is my dax and screen shot

2_1_difference =
VAR _yr = MAX('yarn data'[Stock_finyear])
var _month_max = CALCULATE(MAX('yarn data'[month_sorter]), FILTER(all('yarn data'),
'yarn data'[Stock_finyear] = _yr))

var _month= SELECTEDVALUE('yarn data'[month_sorter])

var _month_calc = if (ISBLANK(_month),_month_max,_month)


var cur_mon_val = CALCULATE(
    SUM('yarn data'[value]),
     FILTER(all('yarn data'),
     'yarn data'[Stock_finyear] = _yr &&
     'yarn data'[month_sorter] =_month_calc
    ))
var Pre_mon_val = CALCULATE(
    SUM('yarn data'[value]),
    FILTER(all('yarn data'),
     'yarn data'[Stock_finyear] = _yr-1 &&
     'yarn data'[month_sorter] =_month_calc
    ))
var val_diff = cur_mon_val -  Pre_mon_val


RETURN
 if(Pre_mon_val <> 0 ,cur_mon_val-Pre_mon_val ,0)

 

 

Need Help
  • sivarajan21's avatar
    sivarajan21
    1 year ago

    Hi JothiG 

     

    Instead of ALL('yarn data'), scope your calculation only to the level you want to override.
    For example, if you want to ignore only some columns but still respect slicers, use ALLSELECTED() or REMOVEFILTERS()

    Try this 

    2_1_difference =
VAR _yr = MAX('yarn data'[Stock_fynear])
VAR _month_max =
    CALCULATE (
        MAX ( 'yarn data'[month_sorter] ),
        FILTER (
            ALLSELECTED ( 'yarn data' ),
            'yarn data'[Stock_fynear] = _yr
        )
    )
VAR _month = SELECTEDVALUE ( 'yarn data'[month_sorter] )
VAR _month_calc = IF ( ISBLANK ( _month ), _month_max, _month )

VAR cur_mon_val =
    CALCULATE (
        SUM ( 'yarn data'[value] ),
        'yarn data'[Stock_fynear] = _yr,
        'yarn data'[month_sorter] = _month_calc
    )

VAR Pre_mon_val =
    CALCULATE (
        SUM ( 'yarn data'[value] ),
        'yarn data'[Stock_fynear] = _yr - 1,
        'yarn data'[month_sorter] = _month_calc
    )

RETURN
    IF ( Pre_mon_val <> 0, cur_mon_val - Pre_mon_val, 0 )

     

    Please let me know if it works

    Best Regards,

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    1 year ago

    Hi JothiG ,

     

    You do not need to have the slicers on the tooptip page since the filter context is passed trough the tooltip and everything gets filtered properly.

     

    What is the exact purpose that you want to achieve with the tooltip? In your print I cannot perceive from what visual you are showing the tooltip.

  • grazitti_sapna's avatar
    grazitti_sapna
    Icon for Super User rankSuper User
    1 year ago

    Hi JothiG , 

    Slicers do sync their filters to tooltips, because tooltips inherit the same filter context as the visual. But if you want slicer selections to be explicitly visible in the tooltip for that I need more details around the same. 

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

    🔗 Curious to explore more? [Discover here].

    Let’s keep building smarter solutions together!

  • sivarajan21's avatar
    sivarajan21
    Icon for Post Prodigy rankPost Prodigy
    1 year ago

    Hi JothiG 

     

    Instead of ALL('yarn data'), scope your calculation only to the level you want to override.
    For example, if you want to ignore only some columns but still respect slicers, use ALLSELECTED() or REMOVEFILTERS()

    Try this 

    2_1_difference =
VAR _yr = MAX('yarn data'[Stock_fynear])
VAR _month_max =
    CALCULATE (
        MAX ( 'yarn data'[month_sorter] ),
        FILTER (
            ALLSELECTED ( 'yarn data' ),
            'yarn data'[Stock_fynear] = _yr
        )
    )
VAR _month = SELECTEDVALUE ( 'yarn data'[month_sorter] )
VAR _month_calc = IF ( ISBLANK ( _month ), _month_max, _month )

VAR cur_mon_val =
    CALCULATE (
        SUM ( 'yarn data'[value] ),
        'yarn data'[Stock_fynear] = _yr,
        'yarn data'[month_sorter] = _month_calc
    )

VAR Pre_mon_val =
    CALCULATE (
        SUM ( 'yarn data'[value] ),
        'yarn data'[Stock_fynear] = _yr - 1,
        'yarn data'[month_sorter] = _month_calc
    )

RETURN
    IF ( Pre_mon_val <> 0, cur_mon_val - Pre_mon_val, 0 )

     

    Please let me know if it works

    Best Regards,