topic Re: line chart and trend chart between two dates in DAX Commands and Tips

line chart and trend chart between two dates

miinseon — Fri, 17 May 2024 02:50:28 GMT

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

Re: line chart and trend chart between two dates

Jihwan_Kim — Fri, 17 May 2024 03:45:28 GMT

Hi,

Please check the below image and the attached pbix file.

Thank you.

Re: line chart and trend chart between two dates

miinseon — Fri, 17 May 2024 04:01:54 GMT

Thanks again 🙂

Re: line chart and trend chart between two dates

miinseon — Fri, 17 May 2024 04:25:17 GMT

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"))

Re: line chart and trend chart between two dates

Jihwan_Kim — Sun, 19 May 2024 04:03:47 GMT

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%"))

Re: line chart and trend chart between two dates

miinseon — Mon, 20 May 2024 00:38:22 GMT

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

Re: line chart and trend chart between two dates

Jihwan_Kim — Mon, 20 May 2024 06:24:43 GMT

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%" ) ) )

Re: line chart and trend chart between two dates

miinseon — Mon, 20 May 2024 07:35:12 GMT

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

really thank you 🙂