Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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 , 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 @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.