Independent control of slicer on measure and visual behavior

[mrlang02]

Hi all,

I have built a report using the following measure.  It provides a way to report an overall batch average of the "VALUE" field.  If you need an explanation of why I did it this way, see this thread.  https://community.powerbi.com/t5/DAX-Commands-and-Tips/Ignore-measure-subgroups-when-charting-and-in...

AverageMeasure:=CALCULATE ( SUM ([Value]), ALLSELECTED( Table ) )
    / CALCULATE ( COUNT (Table[Batch]), ALLSELECTED( Table ) )

I now have another problem to solve.  The above code allows me to calculate the average (XBAR) in the report graph below, based on the input values that are filtered by the 2 slicers.  Is it possible to use the slicers to still perform this function but NOT control the visible range of values?  For instance, can I compute XBAR based on the date range in the slicers, but plot it extended past the date ranges of the slicer?  

[Anonymous · Accepted solution]

You could probably accomplish this with a disconnected date table.  Use one date table to control the date range plotted and the disconnected table to control what dates are used to calculate the XBAR.

The approach, albeit not your exact use case, can be found here: https://www.blue-granite.com/blog/disconnected-table-power-bi

Let me know if that helps.  

Eric

[mrlang02]

Eric,

Thank you very much.  This is exactly what I was looking for! 

Best,

Meghan