Forum Discussion
Blank chart as default
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!
Anonymous , 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/
3 Replies
Anonymous , 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/
hi amitchandak what is [MD By Days]? Is it [Table2[MD] By Table3[Days])?
Hi Anonymous
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.