Forum Discussion

Baarathi88's avatar
Baarathi88
Icon for Helper III rankHelper III
6 years ago
Solved

Area Chart - Secondary Axis

I'm not able to add secondary axis in power bi area chart, are there any criteria for it. Below is my data set

 

I have added axis - Month , Legend - Country , Value - Sales

 

I want to add seconday values as Percentage

 

CountryMonthSalesPercentage
India110012
UK120013
USA130014
France140015
Germany150016
India260017
UK270018
USA280019
France290020
Germany3100021
India3110022
UK3120023
USA3130024
France3140025
Germany4150026
India4160027
UK4170028
India5180029
UK8190030
India8200031
China9500032
India9600036
China1060033
China1150034
China1240035
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Baarathi88 ,

    You can change the type of X-axis from Continous to Categorical to achieve this:

     

    Best Regards,
    Yingjie Li

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

5 Replies