Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am hoping someone can suggest a measure to use as a shared axis in a Clustered Line and Bar Graph visual.
I have a table with two date columns, and I would like to display the count of the dates in each column in a bar graph, grouped by month across a multi-year scale. So for example, if there are 4 dates which occur in April '15 in column 1, and 2 dates in April '15 in column 2, then the bars in the graph above April would be valued at 4 and 2, with the X-axis expanding across the full timeline covered in the columns.
Here's a mockup visual of what I am looking for:
I've tried using a few different methods, such as duplicating one of the columns and transforming it into a Start of Month column and using that as the axis, but the numbers are always wrong in at least one of the counts illustrated by the bars.
Any help would be very much appreciated and rewarded with kudos!
WHen you unpivoted the date axes, did you create a column for receivd and dispatched? You put this new axis on the "ledgend" section
Hi
I have two date columns named Date_Logged and Resolved_time and i need to plot the months in the x-axis till current month.
Im using Line clustered column chart but when i place the measures of Logged and closed_year using date_logged and resolved_time on the shared axis, the count is the same for both bar chart.
And when i use only resolved_time on the shared axis, the count for closed comes correct.
FYI: Logged is calculated based on date_logged
Closed_year is caculated based on Resolved_time.
Attaching snapshot for your reference.
Please guide me through since its quite urgent here at work.
Thanks in advance
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |