Forum Discussion
miinseon
Helper I
Helper Iline 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...
Hi,
Please check the below image and the attached pbix file.
Thank you.
miinseonHelper I
Helper Ican 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
Super User
Super UserHi,
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 helpreally thank you 🙂