Forum Discussion

RY2019's avatar
RY2019
Frequent Visitor
4 years ago

Visual Issue (Combination Whole Number/Percentage)

Hi Power Bi users,   i come with a question and I hope someone could help me:   I have 2 measures % and whole number and I wanted to create a graph where those two measures are combine but the gr...
APavlovs's avatar
APavlovs
Resolver II
4 years ago

Hello RY2019 

 

Don`t think it`s possible with the native visual, since series that are in Column Value are assigned to Primary Y-Axis and the series that are in the Line Value are automatically assigned to Secondary Y-Axis. You don`t have further control over which series from line values are assigned to what Y-Axis.

 

However, this is something you can achieve through 3-rd party visuals. for example this one https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381944

 

It allows you to asign any of the series to any of the axis.

 

I have attached a simple example with the data you had.

 

https://failiem.lv/u/yaqqk7yfd

 

Here are 2 different variations from the same visual

 

 

Did I answer your question? Mark my post as a solution ðŸ™‚ If I gave you an idea on how to solve this otherwise give my post some Kudos 😄