This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hi Folks,
I am trying to create a comparision report. That said i am trying to compare the volume of tickets between 2 calendar years
(Aug2016 to Aug 2017 and Aug 2017 to Aug 2018). I have created two seperate bar charts, Refer attached picture.
How do i combine both or customise the charts to show the comparison report ?
I need to get any of the following combination
I am not sure how to apply the filter because both the graphs have different date ranges.
@Anonymous,
You may use clustered column chart and take advantage of the Legend field.
Hi,
Tried then and no good . As i am comparing a unit value with two different date ranges.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |