Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RY2019
Frequent Visitor

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 graphs that I use is not perfect for it:

 

Here are the tables:

Act

Name31.10.202030.11.202031.12.202031.01.202128.02.202131.03.202130.04.202131.05.202130.06.2021
A200500600800400300200250450
B300600800100400300500350500

 

BDG

Name31.10.202030.11.202031.12.202031.01.202128.02.202131.03.202130.04.202131.05.202130.06.202131.07.202131.08.202130.09.2021
A400300250750350500500250450500250200
B500600750200500400350100500450350250

 

ACT GR (%)

Name31.10.202030.11.202031.12.202031.01.202128.02.202131.03.202130.04.202131.05.202130.06.2021
A0,80,710,511111
B000,5111110,75

 

BDG GR (%)

Name31.10.202030.11.202031.12.202031.01.202128.02.202131.03.202130.04.202131.05.202130.06.202131.07.202131.08.202130.09.2021
A111111111111
B111111111111

 

Here my Graph with the Percentage issue:

RY2019_0-1630486451630.png

 

As you can see in the Line Value I have 3 measures and one of them is whole Numbers. But I need to have the BDG also in the Line Value. But then it comes to the problem that the other two measure in % is showing it wrong in the graph. There is a solution for it?

 

Thanks in Advance for any solution 🙂

 

 

1 REPLY 1
APavlovs
Resolver II
Resolver II

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

 

APavlovs_0-1630569975118.png

 

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 😄

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors