topic Mutiple slicers. If one has no selection - don't show the data on the dynamic chart in DAX Commands and Tips

Mutiple slicers. If one has no selection - don't show the data on the dynamic chart

leeham — Mon, 17 Oct 2022 11:01:50 GMT

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.

Re: Mutiple slicers. If one has no selection - don't show the data on the dynamic chart

v-jianboli-msft — Tue, 18 Oct 2022 08:50:51 GMT

Hi leeham ,

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your data or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Mutiple slicers. If one has no selection - don't show the data on the dynamic chart

leeham — Tue, 18 Oct 2022 08:55:27 GMT

Will do.
I'll try finding sample data as i can easily recreate the problem (do you know of a good sample set?).
I think that'll be easier to share and hopefully will be allowed to pass the work firewall/restrictions.