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.
Hello
I want to express the table below as a line chart, but it is expressed as a chart that looks like a straight line due to little change in value.
Please advise on how to see the trend by date.
<Table>
Date | A | B | C | D | ||||
2021-12-01 | 114,660 | 574,278 | 632,908 | 56,031 | ||||
2021-12-02 | 114,695 | 573,887 | 632,336 | 56,246 | ||||
2021-12-03 | 114,851 | 573,790 | 632,286 | 56,355 | ||||
2021-12-04 | 115,042 | 573,107 | 631,658 | 56,491 | ||||
2021-12-05 | 115,284 | 572,523 | 631,212 | 56,595 | ||||
2021-12-06 | 115,131 | 573,299 | 631,728 | 56,702 | ||||
2021-12-07 | 115,424 | 574,050 | 632,606 | 56,869 | ||||
2021-12-08 | 115,490 | 573,867 | 632,355 | 57,002 | ||||
2021-12-09 | 115,573 | 573,818 | 632,283 | 57,108 | ||||
2021-12-10 | 115,498 | 573,492 | 631,771 | 57,219 | ||||
2021-12-11 | 115,536 | 571,829 | 630,065 | 57,300 | ||||
2021-12-12 | 115,694 | 571,028 | 629,322 | 57,400 | ||||
2021-12-13 | 115,551 | 571,799 | 629,811 | 57,540 | ||||
2021-12-14 | 115,558 | 571,448 | 629,334 | 57,672 | ||||
2021-12-15 | 115,593 | 571,144 | 628,939 | 57,798 | ||||
2021-12-16 | 115,537 | 570,879 | 628,500 | 57,916 | ||||
2021-12-17 | 115,324 | 569,874 | 627,177 | 58,021 | ||||
2021-12-18 | 115,448 | 568,974 | 626,305 | 58,118 | ||||
2021-12-19 | 115,596 | 568,699 | 626,069 | 58,226 | ||||
2021-12-20 | 115,529 | 569,268 | 626,455 | 58,343 | ||||
2021-12-21 | 115,779 | 570,160 | 627,494 | 58,445 | ||||
2021-12-22 | 115,877 | 569,556 | 626,831 | 58,603 | ||||
2021-12-23 | 115,877 | 569,053 | 626,203 | 58,726 | ||||
2021-12-24 | 115,800 | 568,597 | 625,555 | 58,842 | ||||
2021-12-25 | 115,904 | 567,771 | 624,718 | 58,957 | ||||
2021-12-26 | 116,099 | 567,638 | 624,681 | 59,056 | ||||
2021-12-27 | 115,961 | 568,312 | 625,075 | 59,198 | ||||
2021-12-28 | 116,029 | 568,816 | 625,541 | 59,304 | ||||
2021-12-29 | 115,966 | 568,422 | 624,968 | 59,420 | ||||
2021-12-30 | 116,073 | 568,170 | 624,697 | 59,546 | ||||
2021-12-31 | 116,132 | 567,732 | 624,174 | 59,690 | ||||
2022-01-01 | 116,406 | 566,872 | 623,445 | 59,833 | ||||
2022-01-02 | 116,678 | 566,724 | 623,440 | 59,961 | ||||
2022-01-03 | 116,698 | 567,188 | 623,772 | 60,114 | ||||
2022-01-04 | 116,759 | 567,602 | 624,115 | 60,246 | ||||
2022-01-05 | 116,764 | 566,997 | 623,391 | 60,370 | ||||
2022-01-06 | 116,813 | 566,505 | 622,756 | 60,562 | ||||
2022-01-07 | 116,818 | 565,823 | 621,946 | 60,694 | ||||
2022-01-08 | 116,878 | 565,018 | 621,092 | 60,804 | ||||
2022-01-09 | 116,997 | 564,229 | 620,294 | 60,932 | ||||
2022-01-10 | 116,908 | 564,743 | 620,591 | 61,059 | ||||
2022-01-11 | 116,855 | 564,522 | 620,144 | 61,233 |
<Chart>
Hi, @ericjo
Is that what you want?
If yes, there are 3 types of line charts you can tweak.
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
Proud to be a Super User!
Thank you for your answer. I checked the pbix file, but the content I want is slightly different. I want the four A, B, C, and D to be seen as four lines in the chart, not through Slicer.
The four lines in your table will look like in the line chart that you are showing. Would you share some example how you want to look like this line chart. Basically, it is showing 4 lines almost straight.
Proud to be a Super User!
In the existing chart, the line does not appear to change by date. The figure below is in the form of four charts for A, B, C, and D. In conclusion, what I want is whether there is a way to implement the following figure in one chart.
Download the file again. I used custom visual
Proud to be a Super User!
@ericjo , With date on-axis, it should work. But to me seem like the range of data to big, so that line seems straight. Put one measure/column at a time and check
@amitchandak , First of all, thank you for your answer. As the method suggested, we are currently expressing the value by dividing it by one. Is there any way to express it in one chart or in a better way?
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |