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.
I want to do something that is perfectly easy to do in Excel but I can't figure out how to achieve the same in Power Bi.
Suppose I have the following data:
Index | Data | Lower | Upper |
1 | 2 | 1 | 4 |
2 | 4 | 2 | 5 |
3 | 7 | 3 | 6 |
4 | 5 | 4 | 7 |
5 | 7 | 5 | 8 |
I would like to create a diagram where the "Data" column is represented as markers while the columns "Lower" and "Upper" are just dashed lines without markers. In Excel this looks like this
How can I get the same in Power Bi?
Solved! Go to Solution.
Oh, nevermind. I found it. There is a small option "Adapt Series" ("Serie Anpassen" in German, not fully sure about English version), once clicked it expands and I can select marker and line types individually. Well hidden...
Oh, nevermind. I found it. There is a small option "Adapt Series" ("Serie Anpassen" in German, not fully sure about English version), once clicked it expands and I can select marker and line types individually. Well hidden...