Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Love the new x-axis constant line but can't figure this out. Maybe it is not possible?
First question: can you have a constant line show every x period e.g 01 July of every year, or 01 of each month?
Second question: is it possible to use a dax measure instead of manually inputting the constant line, e.g set it to always be first day of previous month? That way it automatically stays relevant without having to manually change it every month.
Solved! Go to Solution.
Hi @dapperscavenger , It is a very cool feature but I don't think it can do measures just yet! You can get the same functionality by changing a line chart to a combo chart, then adding this measure to the columns (keeping the others on the lines):
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Hi @dapperscavenger , It is a very cool feature but I don't think it can do measures just yet! You can get the same functionality by changing a line chart to a combo chart, then adding this measure to the columns (keeping the others on the lines):
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |