cancel
Showing results 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

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

 Name 31.10.2020 30.11.2020 31.12.2020 31.01.2021 28.02.2021 31.03.2021 30.04.2021 31.05.2021 30.06.2021 A 200 500 600 800 400 300 200 250 450 B 300 600 800 100 400 300 500 350 500

BDG

 Name 31.10.2020 30.11.2020 31.12.2020 31.01.2021 28.02.2021 31.03.2021 30.04.2021 31.05.2021 30.06.2021 31.07.2021 31.08.2021 30.09.2021 A 400 300 250 750 350 500 500 250 450 500 250 200 B 500 600 750 200 500 400 350 100 500 450 350 250

ACT GR (%)

 Name 31.10.2020 30.11.2020 31.12.2020 31.01.2021 28.02.2021 31.03.2021 30.04.2021 31.05.2021 30.06.2021 A 0,8 0,7 1 0,5 1 1 1 1 1 B 0 0 0,5 1 1 1 1 1 0,75

BDG GR (%)

 Name 31.10.2020 30.11.2020 31.12.2020 31.01.2021 28.02.2021 31.03.2021 30.04.2021 31.05.2021 30.06.2021 31.07.2021 31.08.2021 30.09.2021 A 1 1 1 1 1 1 1 1 1 1 1 1 B 1 1 1 1 1 1 1 1 1 1 1 1

Here my Graph with the Percentage issue:

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 🙂

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

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 😄

Announcements

#### 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.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### 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
Top Kudoed Authors