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
I'm hoping someone can help me with this line chart. Since I added 2025 Data, the line is not continuous
let me know if you can help.
Solved! Go to Solution.
Wow, this is really interesting now. I got confused at first looking at that as I though that this must have been a DAX issue, that you arechanging the data context through DAX. But then I realised that we can try the following:
1) Set the X-Axis to Continuous
2) Make sure your Date column data type is Date and not text. This step should be done before step #1.
3) If you are not using a distinct dim_date_table, I would create one and connect it to the fact table.
I hope this helps. 😊
All the best,
Michael
Wow, this is really interesting now. I got confused at first looking at that as I though that this must have been a DAX issue, that you arechanging the data context through DAX. But then I realised that we can try the following:
1) Set the X-Axis to Continuous
2) Make sure your Date column data type is Date and not text. This step should be done before step #1.
3) If you are not using a distinct dim_date_table, I would create one and connect it to the fact table.
I hope this helps. 😊
All the best,
Michael
so the X Axis was set to continuous and I changed it to categorical and bingo...
I did have the turn off the labels as they were a bit ugly, but I can use this. Thanks!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 136 | |
| 102 | |
| 68 | |
| 66 | |
| 58 |