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

The Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more

Reply
Abdullah_Hany97
New Member

Using Measure as Axis

I have a measure that calculte the Effectiviness of my team members and this measure is a time dependant which means it changes from month to another, i want to draw a column chart that represent the distrubution of Effectivness which means i want to know how many members have 50% or 60% Effectivness and this distribution changes when i change the time period.
I know it is not applicable to use a measure as X axis but i am asking if there is a walk around. 

2 REPLIES 2
Brunner_BI
Impactful Individual
Impactful Individual

You can use it on your axis using field parameters

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog
Data-estDog
Resolver II
Resolver II

I would look into building a 2nd measure (say, Count Of Effective members) that counts the members with the effectiveness threashold you are looking for (eg 50%). 
Add that to a stacked bar chart with member name, so you can see the count and a color coded member list.

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.