Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I have my dataset in below format.
| Year | Month | Value |
| 2016 | Q1 | 158 |
| 2016 | Q2 | 180 |
| 2016 | Q3 | 139 |
| 2016 | Q4 | 198 |
| 2017 | Q1 | 116 |
| 2017 | Q2 | 147 |
| 2017 | Q3 | 151 |
| 2017 | Q4 | 178 |
Can this be used to create below line chart? I need both the year in same chart. Now what happening is either BI is aggregating both the year or I have to use filter to select individual year.
Solved! Go to Solution.
Yes, please configure as in the screen below:
Thanks,
Prakash
| User | Count |
|---|---|
| 50 | |
| 36 | |
| 29 | |
| 18 | |
| 17 |
| User | Count |
|---|---|
| 66 | |
| 58 | |
| 39 | |
| 21 | |
| 20 |