Forum Discussion

miinseon's avatar
miinseon
Icon for Helper I rankHelper I
2 years ago
Solved

line chart and trend chart between two dates

Hi all 🙂 I created a line chart and a metrics chart where values change based on two selected dates. For the two dates, I created two from & to tables with columns for each. Then I created a me...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    Please check the below image and the attached pbix file.

    Thank you.

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi,

Please try something like below.

 

 

 

ratio =
VAR _Alpha =
    DIVIDE ( ( [@_trend_cnt] - [@_trend_cnt_pm] ), [@_trend_cnt_pm] )
VAR _Beta =
    ABS ( _Alpha )
RETURN
    IF (
        NOT ISBLANK ( _Alpha ),
        IF (
            _Alpha > 0,
            FORMAT ( _Beta, "â–² #,##0.0%" ),
            FORMAT ( _Beta, "â–¼ #,##0.0%" )
        )
    )
miinseon's avatar
miinseon
Icon for Helper I rankHelper I
2 years ago

it works!!
I couldn’t have done it without your help

really thank you 🙂