Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
So i create a line chart for my dashboard, the x axis is from the week. The problem is when it comes to another year like 2024, it show a blank value between last 2023 week (202352) and 2024 first week (202401) and my line is bit messy. Anyone know how to fix that?
@lilbsb
You can check if the mesure youare ausing returns a value using if like:
New Measure = IF ( NOT ISBLANK(YourMeasure) , YourMeasure )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
well actually i dont have blank value on my week table, 202401 came after 202352 😄
Okay thanks for the help, i will read the link first, thankyou once again! aprriciate that 😄
@lilbsb follow up on this discussion: https://community.fabric.microsoft.com/t5/Desktop/Non-continuous-line-chart-data/m-p/13722
Several approaches are mentioned.
Kudos and mark as solution appreciated.
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |