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 check the below image and the attached pbix file.

Thank you.

 

 

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

    Thanks again 🙂

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

    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's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      2 years ago

      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's avatar
        miinseon
        Icon for Helper I rankHelper I
        2 years ago

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