Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I'd like to set up a clustered column chart to show the changes in target duration from this current fiscal year compared to the previous fiscal year.
There are 5 work order categories with different target duration times. I'd like to display this in a column chart with the Work orders desccription on the X axis and the columns representing target durations for FY21/22 vs FY22/23. However, my target duration values are aggregating and showing the count for each target duration category. Is there a way to mimic the values shown on my matrix to a clustered column chart.
Something like the below (without aggregating values)
My two target duration columns are set to Text format and are not summarized.
Thank you
Solved! Go to Solution.
You can either:
a) Change the field type in Power Query or table view to whole number
b) if you need the values as text for other purposes, you can convert the text field to a number using a measure:
Text as number measure =
VALUE(MAX('Table'[Filed as text]))
Proud to be a Super User!
Paul on Linkedin.
Hi @Anonymous , How is your data structured? I tried to replicate based on the information provided and was able to get the below result just by turning the matrix into a clustered column chart.
Is this your desired end result?
Hi @johncolley , yes that is exactly the result I'm trying to acheive! When I try to convert my matrix to a clustered column chart, the target values move to the tooltips section. When I try to move them to the "values" section, that is when it aggregates to show the count of the values.
I have two seperate columns for these target values and currently set up as "text" data type.
You can either:
a) Change the field type in Power Query or table view to whole number
b) if you need the values as text for other purposes, you can convert the text field to a number using a measure:
Text as number measure =
VALUE(MAX('Table'[Filed as text]))
Proud to be a Super User!
Paul on Linkedin.
Thank you! That worked perfectly. I had tried to change the data type to a whole number previously in my data table, but I guess I had to change it directly from power query.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
91 | |
87 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
110 | |
96 | |
70 | |
67 |