The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
The both axis in my clustered column chart don't work and I don't know why.
First, I create 2 separate clustered column charts, one for COM, one for RESP (left part).
Then, I tried to get one with both data but, when I add 2 axis (COM and RESP), always the first one is taken into account but not the second one. I guess it is normal but I don't know how to get round it. Somebody has an idea ?
For information, here is a part of the content of the table Sheet1 (very simple).
Regards,
CR
Solved! Go to Solution.
Hi jthomson,
You're right. I tried to proceed like this and it finally worked!
I created a new table with all the YEAR - MONTH combinaison and I count the number of COM and RESP in this table.
Then I drag and drop appropriate columns in the clustered column chart as follows:
So cool...
Regards,
CR
Hi,
I am trying to show two parameters on x axis region and deposits and y axis has one parameter how I can make graph like that in Power BI Desktop.
Easier to make a date table, or at least a table with all the relevant months listed, and link to your two tables from that. Then use the new table's column as your x axis
Hi jthomson,
You're right. I tried to proceed like this and it finally worked!
I created a new table with all the YEAR - MONTH combinaison and I count the number of COM and RESP in this table.
Then I drag and drop appropriate columns in the clustered column chart as follows:
So cool...
Regards,
CR
User | Count |
---|---|
81 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |