Icon for Advocate I rank

Advocate I

4 years ago

Status:

Investigating

Measure Driven Axis (Min/Max) not sensitive to cross filtering from other visuals

I am using measures for the Min and Max of 'Line and Clustered Column' Chart.

However it seems that the min and max aspects of an axis are not sensitive to cross filtering by other visuals.

See 2 pics below for reference

Not cross filtered - works fineCross filtered - big issue!

Also here is the measure being used:

Some Measure Max =

VAR Tab =

ADDCOLUMNS(

SUMMARIZE('Date','Date'[FY],'Date'[MonthShort])

,"Leads",[Some Measure]

)

VAR Mn = MINX(Tab,[Leads])

VAR Mx = MAXX(Tab,[Leads])

VAR Dif = Mx-Mn

VAR Dif2 = IF(Dif=0,10,Dif)

VAR Noughts = TRUNC(LOG10(Dif2))

VAR GridMn = FLOOR(Mn,10^Noughts)

VAR GridMx = CEILING(Mx,10^Noughts)

RETURN

GridMx

1 Comment

v-cazheng-msft
Community Support
4 years ago
Status changed:
New
to
Investigating
Hi DingbatData

Not very sure what your expected result is, but I think you can switch your line and clustered column chart to table chart firstly and then make a little bit change to your measure to check the result of each variable in your measure.

For example, you can modify your measure as follows to check the value of Mn.

Some Measure Max =

VAR Tab =

ADDCOLUMNS(

SUMMARIZE('Date','Date'[FY],'Date'[MonthShort])

,"Leads",[Some Measure]

)

VAR Mn = MINX(Tab,[Leads])

VAR Mx = MAXX(Tab,[Leads])

VAR Dif = Mx-Mn

VAR Dif2 = IF(Dif=0,10,Dif)

VAR Noughts = TRUNC(LOG10(Dif2))

VAR GridMn = FLOOR(Mn,10^Noughts)

VAR GridMx = CEILING(Mx,10^Noughts)

RETURN

/*GridMx*/Mn

If you have checked each variable’s result and you still couldn’t find the cause, could you please provide some sample data related to your issue and show me your expected result? Thanks in advance.

Best Regards,

Community Support Team _ Caiyun

Completed Ideas