Forum Discussion

GiTchitchinadze's avatar
GiTchitchinadze
Frequent Visitor
3 years ago
Solved

Selected Year Side By Side Comparison In chart

Hi guys,   I want to create a bar chart or any other chart that will include loss ratio data from two selected years. (for example, if i choose 2020 and 2022 it has to show both of them side by sid...
bar chart
comparing two different years.
side by side comparison
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi GiTchitchinadze ,

     

    If you want the chart to display selected years side by side, you need to change your X-axis(remove year from the date hierarchy)

    Based on your description, I have created a simple sample:

    Please try:

    Loss Ratio = DIVIDE(SUM('Table'[Loss Ammount]),SUM('Table'[Sales Ammount]))

    Apply it to the visual:

    Then create a slicer for year:

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi GiTchitchinadze ,

 

If you want the chart to display selected years side by side, you need to change your X-axis(remove year from the date hierarchy)

Based on your description, I have created a simple sample:

Please try:

Loss Ratio = DIVIDE(SUM('Table'[Loss Ammount]),SUM('Table'[Sales Ammount]))

Apply it to the visual:

Then create a slicer for year:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.