show 'blank' instead of taking the smallest value by default

[user83]

hello,

Any idea of this is appreciate ;

Situation :  if I don't select in card visualization any of the following fields (example Q1,Q2,Q3,...)  PBI shows me by default Q1 , how to make it not display anything instead

Thank you 🙂

user83

[v-deddai1-msft · Accepted solution]

Hi @user83 ,

Do you have any slicer for the filed(Q1,Q2,Q3,Q4)? You can use the measure like:

Measure =  IF(ISFILTERED('Table'[Qtr]),CALCULATE(…),BLANK())

Best Regards,

Dedmon Dai

[amitchandak]

@user83 , How is your date table structured, it depends on that

something like this

Measure =

var _qtr =if(isfiltered(Date[Qtr]),maxx(allselected(Date),Date[Qtr]), maxx(filter(Date,Date[Year] =year(Today())),Date[Qtr]))

return

calculate(.....)

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