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 all,
I am showing a bar graph to the clients. The graph is a monthly chart with months on x-axis. I need a vertical dashed or dotted line after one specific month. I cnnot put any shape or image because there is scroll in my chart. Is it possible to do it?
Any help is highly appreciated!
Regards,
Yashwant
Solved! Go to Solution.
Hi @yashwant101 - i have used with some sample data and in line chart you can use reference line and based on date create a measure and add conditional formatting.
can you try the above logic
Proud to be a Super User! | |
Hi @yashwant101 - Create a calculated column in your date table that identifies the specific month after which you want to add the vertical line. This calculated column can contain a flag or indicator for the specific month.
LineIndicator = IF('DateTable'[Month] > DATE(2023, 5, 1), 1, 0)
example: i have taken may month
Drag the LineIndicator calculated column to the "Values" or "Legend" field well.Change the aggregation method to "Don't summarize" or "Don't summarize (single)" depending on your Power BI version.Format the line as a dashed or dotted line.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Hi @rajendraongole1 ,
Can you please provide a file with the implementation? I am having issues implemeting it.
Regards,
Yashwant
Hi @yashwant101 Expecting the sample file from your end, because you know the data and expectations, share it with us,will check from our end.
Proud to be a Super User! | |
Hi @rajendraongole1 ,
I have not been allowed to share file yet but I can attach a screenshot:
Below is the expected graph:
In the above line and bar chart, we have a vertical dashed line for Oct-2023. That indictes that there was a significant change related to the orgnization in that month. I want to do this in Power BI for specific month.
Hi @yashwant101 - i have used with some sample data and in line chart you can use reference line and based on date create a measure and add conditional formatting.
can you try the above logic
Proud to be a Super User! | |
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
186 | |
93 | |
67 | |
63 | |
54 |