Forum Discussion

insp77's avatar
insp77
Frequent Visitor
4 years ago
Solved

Display Data Label on the last date for multiple lines chart in power BI

Hi, I have a data set where 3 or the 4 column varaibles are filtered  and plotted.  Current my chart shors Growth Since Feb-2020 for 3 selected categories and selected geography.  I generated a BI l...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  insp77 ,

    Here are the steps you can follow：

    1. Create table with Enter data.

    2. Create measure.

    Measure_Growth From Feb-2020 =
CALCULATE(SUM('Table'[Growth From Feb-2020]),FILTER(ALL('Table'),'Table'[DATE]=MAX('Table'[DATE])&&'Table'[Class Of Workers]=MAX('Table2'[Table2Class Of Workers])))

    3. Result:

     

    Best Regards,

    Liu Yang

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