Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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.
| User | Count |
|---|---|
| 50 | |
| 37 | |
| 29 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 73 | |
| 59 | |
| 39 | |
| 22 | |
| 21 |