filter data with 0 numbers

[Katerina_SL]

Hello Everyone! 

I would like to ask help.

I've created bar chart in Power BI where on axes X is dates (hierarchy), on Y - number of options per day. 

Also I have filter dates.

I have problem when I would like to see on bar chart also days where we had no options. For it I wrote function: if (isblank(distinctcount(option_id)), 0, distinctcount(option_id)). After this I can see all days, even when we had 0 options but I can't filter now. For example, when I choose April 2023, on bar chart all days except April 2023 will be with 0, but you still see this graph and I would like to see only April 2023 on graph. 

This problem I have when I'm using filter between. When I'm using hierarchy in filter too, everything is okay. But I would like to use Between and have posibility to choose exact week. 

Thank you very much for advises,

Ekaterina

[Ritaf1983]

Hi @Katerina_SL .

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523