Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
104 | |
69 | |
48 | |
41 | |
34 |
User | Count |
---|---|
164 | |
112 | |
62 | |
54 | |
38 |