Show data when selected particular bar for a date

[Anonymous]

Hello All,

I have a report where I am showing dates and health in bar chart.

Now when I clicked on the perticular bar I need to show corresponding sales for that bar.

So I made interactions and working fine and to show nothing by default I am using below dax logic.

SalesLogic =

var _check = calculate(isfiltered('Global Stats'[TrendDate]), allselected())

return

if(_check, [Sales], blank())

Its working fine, Also I need to show profit also when I click on the bar for perticular date,

But its not showing profit if I use the same logic like below.

ProfitLogic =

var _check = calculate(isfiltered('Global Stats'[TrendDate]), allselected())

return

if(_check, [Profit], blank())

I am I missing something.

Could any one please help

[PVO3]

IF(HASONEVALUE('Global Stats'[TrendDate]),[Profit])

If thats not working, maybe your [Profit] measure is using your [TrendDate] in some way or another.

[Anonymous]

Hi @PVO3 ,

Your solution is working fine, but I am not able to see the conditional formatting option to change my colors based on profit values.

[PVO3 · Accepted solution]

You are using a legend. If you remove the legend you can add this.

[amitchandak]

@Anonymous , Check for Hasonevalue too

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