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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors