Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |