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

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.

Reply
cowboyracer
Frequent Visitor

Can't get my data right in multi axes chart

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:

  1. Fullname (names of employees) From Table 3: “employees”
  2. Count of descriptions of cases from Table 2
  3. Date (created on or after…) from Table 2
  4. Is this a request to call back the customer (all – yes and no) This comes from Colomn C (True/False type), in Table 1
  5. The name of the department (from Colomn A) it needs to show is… From Table 1

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
Screenshot1.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2 ALL THE CALLS FOR 1 TEAM… 143 = all, 21= with request to call back, 122 = no request to call back

Screenshot2.jpg

 

3. NOW CHART TYPE = xVIZ MULTIPLE AXES

Screenshot3.jpg

 

4. MEASURE OF CALL BACK = TRUE

Screenshot4.jpg

 

 

 

 

1 REPLY 1
v-xuding-msft
Community Support
Community Support

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.

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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