Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The current visual contains 2 colomns from 2 Tables.
Colomn A in Table 1 = A text type (“names of departments”) –> Axis
Colomn B in Table 2 = A text type (“descriptions of cases”) –> Values
There are now the following fiilters on the visual:
Now it shows all the calls to the five teams of one department.
I want to make a multiple axes chart.
I thought I’d show 3 bars per team: All the calls/the ones with a request to call back/the ones without a request to call back/
But I can’t get it right:
Table 4 contains two measures (they are DAX – so I guess they are measures, not quick measures – I didn’t made them…).
"Call back to customer is needed"
"Call back to customer is not needed"
I thought could use them…
If I drag these measures to Value axis 2 and Values axis 3 (Value axis 1 contains the count of descriptions of cases) it seems to lose the filter on the wanted department, the bars (dark blue and red) show the same numbers for all 5 teams: all the “yes/no call backs”…
Who can help me with this?
Kind Regards,
Simone
1 CURRENT VISUAL – With all the calls for entire department 456 = all, 77= with request to call back, 379 = no request to call back
2 ALL THE CALLS FOR 1 TEAM… 143 = all, 21= with request to call back, 122 = no request to call back
3. NOW CHART TYPE = xVIZ MULTIPLE AXES
4. MEASURE OF CALL BACK = TRUE
Hi @cowboyracer ,
Do you mind sharing your .pbix file? Or please show me the sample data. Then I will understand more clearly about your issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |