The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I have a line and stacked column chart with some financial values as y axis and impact % as secondary y axis. My x is month values which relate to the impact % however my financial values are now starting on the same date as my impact % values. the financial values are dependent on another date column. How do I condition my financial values to start on the graph based on the other date column that i have ?
@Mart1980 please provide some sample data with the expected output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hello @parry2k ,
Please find the link here to the dataset I have. test12.xlsx - Google Sheets
and here is what i got so far in Power BI:
So Month comes from column C. Financial gain starts from Jan 23 in this case but the live date for project x would be november 2023. so I want my financial gain to start from that date rather than the months of % impact