Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi
I am new to power BI and trying to replicate a chart I commonly plot in excel. I have the line chart setup in power BI, but would like to show the running difference between value on different dates (Snapshot attached).
Greatly appreciate your help!
Power BI Chart:
Desired Chart
@Anonymous ,
Change X-axis type to Categorial like below screen shot.
Don't forget to hit Thumbs up and accept this as a solution if you find it helpful!
Hi @Tahreem24 thanks for the reply. The problem is not so much with displaying date format. I want to add the difference bars on alternate axis. Basically trying to visualize a table like this:
11/25/2019 | 11/29/2019 | 12/6/2019 | 12/8/2019 | 12/9/2019 | |
Value | 385736 | 386685 | 384155 | 393050 | 382790 |
Running Diff | 949 | -2530 | 8895 | -10260 |
1. I dont know how to calculate the Running diff in Power BI.
2. How do i display this on the chart
@Anonymous ,
Step 1: Create Index column in Query Editor. Go to Query Editor --> Select Add COlumn Menu --> Choose Index Column --> Apply and Close Editor
Step 2: Create Calculated column like below:
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |