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.
I want to show the number of items created by year and number of items closed by year on the same clustered column chart. How can I do that?
Solved! Go to Solution.
Hi @sanman
Both of the above solutions can successfully achieve what you want. I illustrate both in my understanding with images below in case you need it.
Solution 1:
1. In query editor, select CreateYear and ClosedYear columns and unpivot them.
2. Create a clustered column chart like below.
Solution 2:
1. Create a year table, then create an active relationship ‘Items (2)’CreateYear(*) – ‘Year’Year(1) and an inactive relationship ‘Items (2)’ClosedYear(*) – ‘Year’Year(1).
2. Create a measure using Userelationship function as below.
Count of Closed = CALCULATE(COUNTROWS('Items (2)'),USERELATIONSHIP('Items (2)'[ClosedYear],'Year'[Year]))
3. Create the clustered column chart.
Best Regards,
Community Support Team _ Jing Zhang
Hi @sanman
Both of the above solutions can successfully achieve what you want. I illustrate both in my understanding with images below in case you need it.
Solution 1:
1. In query editor, select CreateYear and ClosedYear columns and unpivot them.
2. Create a clustered column chart like below.
Solution 2:
1. Create a year table, then create an active relationship ‘Items (2)’CreateYear(*) – ‘Year’Year(1) and an inactive relationship ‘Items (2)’ClosedYear(*) – ‘Year’Year(1).
2. Create a measure using Userelationship function as below.
Count of Closed = CALCULATE(COUNTROWS('Items (2)'),USERELATIONSHIP('Items (2)'[ClosedYear],'Year'[Year]))
3. Create the clustered column chart.
Best Regards,
Community Support Team _ Jing Zhang
@sanman , Create a year table join it with both Create year and close year. One will active another one will be inactive. Use userelation to in the measure to change date
This video has an HR example - but applies here too -
Refer
@sanman - I *think* you need to unpivot your year columns. Use Attribute as the legend, Value as the axis. Count of itemname for value
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |