Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 143 | |
| 124 | |
| 101 | |
| 80 | |
| 55 |