Blank chart as default

[Alex_0201]

Hi everyone. How does one make a chart (in this case line chart) blank unless a slicer value is selected?

Here is how it looks now. It's confusing for engineers due to aggregation of MD:

Here is how it should like before choosing a slicer on the left and after having chosen one - on the right:

Thanks in advance!

[amitchandak · Accepted solution]

@Alex_0201 , Try like

new MD By Days= if(isfiltered(Table[Well]),[MD By Days],blank())

refer

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[Alex_0201]

hi @amitchandak what is [MD By Days]? Is it [Table2[MD] By Table3[Days])?

[v-rzhou-msft]

Hi @Alex_0201 

 amitchandak shows you a good way by using isfiltered function and you may try to use hasonefilter function as well.

I build a table to have a test.

Build a measure:

M_MD = IF(HASONEFILTER('Table'[Well]),SUM('Table'[MD]),BLANK())

Result:

Blank chart as default:

 

Select the slicer.

You can download the pbix file from this link: Blank chart as default

Best Regards,

Rico Zhou

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