I have a dynamic line chart and 3 slicers (more to come).
Each slicer has been created using the preview feature - Field Parameters - and each slicer may contain 4 or more measures/selections in each.
When the user selects a measure within the slicer, it is then added to the line chart.
This allows the user to see multiple measures on one chart.
When the user does not pick a measure from the slicer, Power BI defaults to showing all the measures instead of none.
I made an attempt to prevent this by making the measure below, however, it blocked all data appearing on the chart, even ones from the slicers that had a selection.
For more context:
Slicers:
Region
Open year
product
Chart:
Measures missed payments.
For the region, I made this measure and added it as a new data field to the chart
regionfilt=
INT(ISFILTERED(Region[Region Fields]))
The chart applies this as logic when IS 1.
However, when no region is chosen (so the user is not interested in charting a region) the chart goes blank, even if the user selects a product to chart.
Is there a way to make that region measure only apply to the region selections?
The solution will be to apply this logic to the other field slicers - product and open year - so that the user can ignore those too if they -for example - only want to focus on region.
Thanks.
