Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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.
You can use it on your axis using field parameters
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.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 29 | |
| 28 | |
| 27 | |
| 27 | |
| 19 |
| User | Count |
|---|---|
| 56 | |
| 47 | |
| 39 | |
| 27 | |
| 21 |