Disable specific filter on tooltip chart

[harshadrokade]

Hi All,

Appreacite your help on his in advance.

I have below data

Month-DD/MM/YYYY	Value	Student name	Subject name
01/01/2020	100	A	ABC1
01/03/2020	80	A	ABC1
01/08/2020	90	A	ABC1
01/12/2020	70	A	ABC1
01/01/2020	70	A	ABC2
01/03/2020	80	A	ABC2
01/08/2020	90	A	ABC2
01/12/2020	100	A	ABC2
01/01/2020	10	B	ABC1
01/03/2020	100	B	ABC1
01/08/2020	70	B	ABC1
01/12/2020	40	B	ABC1
01/01/2020	30	B	ABC2
01/03/2020	80	B	ABC2
01/08/2020	30	B	ABC2
01/12/2020	10	B	ABC2

I have created multi row card based on few parameters & data in that card shown on date level like example given below

Card1

01/01/2020

100

A

ABC1

Card2

01/03/2020

80

A

ABC1

Card3

01/08/2020

90

A

ABC1

etc..

I have a tooltip column chart created with latest two dates filtered on filter pane of the chart. This chart is shown on hovering the multi row card but when I hover on multi row card of a specific month, it shows the value only of that month & not recent two months.

How to get to see recent two month values on hovering on any specfic date card of multi row card?

[v-shex-msft]

HI @harshadrokade,

Can you please share some more detail about the custom tooltip chart design and filter settings? They will help us clarify your scenarios and test.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[harshadrokade]

Hi @v-shex-msft 

I have created a tooltip chart as below where I have added a filter that filters the chart by showing latest 2 dates on X axis. I want to show this chart on card visual (Shown below) when I hover on a specific card from the multi card. The issue is when I hover on the card, it shows me only latest year on tooltip bar chart. It may be because the card visual also has a filter applied as mentioned below-

Sample dummy data-

Month-DD/MM/YYYY	Value	Student name	Subject name
01-01-2020	100	A	ABC1
01-03-2020	80	A	ABC1
01-08-2020	90	A	ABC1
01-12-2020	70	A	ABC1
01-01-2020	70	A	ABC2
01-03-2020	80	A	ABC2
01-08-2020	90	A	ABC2
01-12-2020	100	A	ABC2
01-01-2020	10	B	ABC1
01-03-2020	100	B	ABC1
01-08-2020	70	B	ABC1
01-12-2020	40	B	ABC1
01-01-2020	30	B	ABC2
01-03-2020	80	B	ABC2
01-08-2020	30	B	ABC2
01-12-2020	10	B	ABC2
01-01-2020	40	A	ABC3
01-03-2020	30	A	ABC3
01-08-2020	80	A	ABC3
01-12-2020	100	A	ABC3
01-01-2020	10	B	ABC3
01-03-2020	100	B	ABC3
01-08-2020	70	B	ABC3
01-12-2020	40	B	ABC3
01-01-2020	40	A	ABC4
01-03-2020	30	A	ABC4
01-08-2020	80	A	ABC4
01-12-2020	100	A	ABC4
01-01-2020	10	B	ABC4
01-03-2020	100	B	ABC4
01-08-2020	70	B	ABC4
01-12-2020	40	B	ABC4

Multi card visual with filter aplied to show only latest year data. So when you hover on latest card of a specific Subject (filtered on latest month), you should be able to see last two period bar chart created on tooltip chart tab.

As of now it shows the column chart of only latest year as below. I want to see previous year comparison on column chart for the selected student & subject on which hover is done.

[v-shex-msft · Accepted solution]

Hi @harshadrokade,

I think you need to change your tooltip report page DAX expression to add 'all' functions to ignore the current filter and add variables to store and calculate the previous date period.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

Then you can use this variable as a condition to calculate corresponding results.

formual =
VAR currDate =
    MAX ( Table[Date] )
VAR prevDate =
    DATE ( YEAR ( currDate ) - 1, MONTH ( currDate ), DAY ( currDate ) )
RETURN
    CALCULATE (
        SUM ( Table[Value] ),
        FILTER ( ALL ( Table ), [Date] = prevDate ),
        VALUES ( Table[Student name] ),
        VALUES ( Table[Subject name] )
    )

Regards,

Xiaoxin Sheng

[harshadrokade]

Hi @v-jayw-msft Can u pls help here..