Forum Discussion

Katerina_SL's avatar
Katerina_SL
Helper II
2 years ago

filter data with 0 numbers

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