line chart and trend chart between two dates

[miinseon]

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 measure to get the values I wanted.
The line chart came out just as I wanted.
However, the metrics chart looks like the image below.
The first month doesn't show the previous month's value and the last month adds an extra month.

I'll attach the file : pbix 

Please let me know how to fix it if you can.

Thanks

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below image and the attached pbix file.

Thank you.

[miinseon]

can i ask one more thing??

i modify ratio dax to show ratio like ▲ 13.5 %

but all date columm shown like bwelow image

my modified dax 

ratio =

var _Alpha = DIVIDE ( ( [@_trend_cnt] - [@_trend_cnt_pm] ), [@_trend_cnt_pm] )

var _Beta = ABS(_Alpha)

 RETURN

    IF(_Alpha > 0, FORMAT(_Beta,"▲ #,##0.0"), FORMAT(_Beta,"▼ #,##0.0"))

[Jihwan_Kim]

Hi,

Please try adding %, something like below, whether it suits your requirement.

ratio =
var _Alpha = DIVIDE ( ( [@_trend_cnt] - [@_trend_cnt_pm] ), [@_trend_cnt_pm] )
var _Beta = ABS(_Alpha)

 RETURN
    IF(_Alpha > 0, FORMAT(_Beta,"▲ #,##0.0%"), FORMAT(_Beta,"▼ #,##0.0%"))

[miinseon]

Hi
Modifying the dax will turn it into text and show all dates in the column.

[Jihwan_Kim]

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]

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

really thank you 🙂

[miinseon]

Thanks again 🙂