Forum Discussion

vkedd's avatar
vkedd
Regular Visitor
2 years ago
Solved

Unable to filter graph based on slicer selection

Hey all! Have been working with PowerBI for a bit, but this one has me needing assistance.   I have a bar/line chart combo with Creation Date on the X axis, TCV and Deal count on the y axis. I also...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I feel like you are going down the wrong path in your design.  Generally in measures you just want to use the context to get to your result.  I'd approach it more like:

    Graph Output = var startDate = MIN('table1'[Fiscal Period])
var endDate = MAX('table1'[Fiscal Period])
RETURN
CALCULATE(
	SUM('table1'[YourOutputValueColumn]),
	ALL('table1'),
	'table1'[Create Date fiscal Period]) >= startDate,
	'table1'[Create Date fiscal Period]) <= endDate
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I feel like you are going down the wrong path in your design.  Generally in measures you just want to use the context to get to your result.  I'd approach it more like:

Graph Output = var startDate = MIN('table1'[Fiscal Period])
var endDate = MAX('table1'[Fiscal Period])
RETURN
CALCULATE(
	SUM('table1'[YourOutputValueColumn]),
	ALL('table1'),
	'table1'[Create Date fiscal Period]) >= startDate,
	'table1'[Create Date fiscal Period]) <= endDate
)