Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello, I am facing issue with multiple axis line chart. I am looking for a solution where second axis in line chart should not get split by legend.
Chart - Line chart
X axis - Month-Year
Y axis1- Total Time
Y axis2 - Average time
Legend - Region
In chart below when I select Country as India in filter, I want my chart to show another average line for Country India but currently it even splits the Average time by region(legend).
Data is as below:
Month Year | Country | City | Total Time |
2023-05 | India | Banglore | 190 |
2023-06 | India | Banglore | 200 |
2023-07 | India | Banglore | 10 |
2023-05 | India | Mumbai | 9 |
2023-06 | India | Mumbai | 10 |
2023-07 | India | Mumbai | 10 |
2023-05 | Australia | Sydney | 200 |
2023-06 | Australia | Sydney | 200 |
2023-07 | Australia | Sydney | 180 |
2023-05 | Australia | Melbourne | 90 |
2023-06 | Australia | Melbourne | 10 |
2023-07 | Australia | Melbourne | 20 |
2023-05 | US | Atlanta | 50 |
2023-06 | US | Atlanta | 50 |
2023-07 | US | Atlanta | 40 |
2023-05 | US | Chicago | 80 |
2023-06 | US | Chicago | 100 |
2023-07 | US | Chicago | 120 |
@Ahmedx @amitchandak @Ritaf1983 @parry2k , requesting you to help on this problem. Thanks in advance
@Ahmedx @amitchandak @Ritaf1983 @parry2k , requesting you to help on this problem. Thanks in advance
Hi @Snapdrag ,
Please try this way:
I create a DAX below to calcaulate the average time:
Average Time for Country =
CALCULATE(
AVERAGE('Table'[Total Time]),
ALL('Table'[City]),
ALLEXCEPT('Table', 'Table'[Country])
)
The results are as follows:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I want a trend linefor the average in the same way I have for total but the requirement is that average line should not get split by legend.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |