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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
matout
Helper I
Helper I

Charts shows static value for secondary dimension

Hello all,

 

I am relativly new to PowerBI, I am still trying to figure things out in it.

 

I am trying to create a chart that shows the commulative value of compnaies per number of employees they have

for example 

Year 2012

Number of employees Number of companies
16565
23434
323534


Year 2010

Number of employees Number of companies
132232
233422
32123

 

My problem is that every chart type shows the first dimention correctly, and the second dimention to be a static number

like this

 

the x axis is caterogical (num of employees) and the y axis is the number of companies

powerBI visual.PNG

 

No matter which visual I use, it is still the same

1 ACCEPTED SOLUTION

Hi @matout ,

 

You will need an active relationship between these tables

1.PNG

2.PNG

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@matout , You can change axis scale type - Log

https://youtu.be/iYNVKXJJkCw?t=68

 

I also doubt that one the table for the measure is not joined with the table used on axis.

Hello,

 

It still does the same behavior, even though I the y axis is log and the x is caterogical.

I also used the clustered column and line chart with no luck.

 

As for the joing, they are not joined as I will lose some values.

However, they have one to one relationship with each other.

 

matout_0-1601901738701.png

 

Hi @matout ,

 

You will need an active relationship between these tables

1.PNG

2.PNG

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
VijayP
Super User
Super User

@matout 

This is becasue the Values of Employees are very less and number of companies value is very high

Use Combination Chart (Line and Column Chart to show the information accurately)

VijayP_0-1601880611914.png

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.