Forum Discussion

Fantmas's avatar
Fantmas
Helper III
4 years ago
Solved

Create Waterfall Chart with breakdown based on date Selected value

Hi all,   I am new in the PowerBi journey, I am trying to create a waterfall that display movement from based on a date value in a slicer,   in my measure I got the following error message and I ...
  • Fantmas's avatar
    Fantmas
    4 years ago

    Hi,

    Thank you for your feedback, it sems working now,

    I amr requesting a last support from powerBi community , I Try get the sum of previous month value based on Slicer selection my code return me blank and I do not understand why :



     

    M-1 = Calculate( [FTE MTD], REMOVEFILTERS( DimDate[Date] ), 'Fact FTE'[Period Available] = EOMONTH( SELECTEDVALUE(DimDate[Date]),-1))

     

     

     

Fantmas's avatar
Fantmas
Helper III
4 years ago

Hi Amit,

it seems working now, I have an additional question, is it possible to do a dynamic title for the category,

When the user select the date he want to see, the column title will change depending of the selected date ?

Thank a lot for your support

Regards


v-yadongf-msft's avatar
v-yadongf-msft
Community Support
4 years ago

Hi Fantmas ,

 

Maybe you can use drill down function to do a dynamic title for the category.

 

When you drill down, the column title will change depending of the selected date.

 

Best regards,

Yadong Fang

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