Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
ericjo
Helper I
Helper I

Line chart expression method with little change in y value

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> 

ericjo_1-1643172199098.png

 

7 REPLIES 7
ALLUREAN
Solution Sage
Solution Sage

Hi, @ericjo 

Is that what you want?

https://www.dropbox.com/s/p5f8r8h6i9kndo1/Line%20chart%20expression%20method%20%28allure-analytics.c...

 

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://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
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.




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

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.

ericjo_0-1643178228904.png

 

Download the file again. I used custom visual




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




amitchandak
Super User
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?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.