The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Description:
I am currently working on a Power BI project where I have encountered an issue with combining a column chart and a line chart in the same visual. Let me describe the scenario and the problem in detail:
Scenario:
I have two measures in my Power BI report:
On the X-axis, I am displaying "Month Year."
On the Y-axis, I am showing "Market Inventory Days" in a column chart.
Desired Visualization:
Current Setup:
What I've Tried:
Request you to kindly help me with some workaround with this or suggest any custom visual.
I have attempted to utilize the provided visualization tool, but the issue I encountered is that it does not support legends for lines; it only allows legends to be applied to columns. Please see the screenshot.
Hi @Shahabh786
There is a Bar & Line Chart visual that you could use. It will mean both measures can be used in one Visual.
Joe
I have attempted to utilize the provided visualization tool, but the issue I encountered is that it does not support legends for lines; it only allows legends to be applied to columns. Please see the screenshot.
This isn't an ideal work around, but you could try the following if the line legend won't change or is a single value.
Remove all value fields except for the Line. This should provide a legend. Take a screenshot of the legend and then import the screenshot as a visual. Set up the Visual with the Column legend and then layer the picture beside the other legends. open the selection part and make sure that the visual is lower in the list than the screenshot.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |