Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
BHS_KI
Regular Visitor

How to illustrate two groups of measures from one column in an overlay (picture encloses)

Hello,

 

I have a requirement to show measure results depending on different temperatures (ambient temperature about 20 degree and heated temperature above 90 degree). There are several test rows showing the results depending on time and temperature. 

 

For the two temperatures areas (ambient and heated) I want to compare the results as show below, but with different colors per temperature area (ambient and heated) and not connect to eachother as show. My way to show was just limited. Sorry for that. 

 

The goal is t show that I can achieve a better result wih heated or ambient temperature. 

 

 

BHS_KI_0-1686218718663.png

 

Here the data table

 

Test-No.Temp  (°C)Time/ secResult
199,51018
21012012
3100,2308
499,45406
599,8505
699,52604
7102703,5
8101803
9100,3902,5
1099,61003
11201018
1220,32016
1320,43013
14214011
1520,3509
1619,8608
1722707
1821806
1920,3905
20211004

 

Thanks so much in advance. 

 

reg. Klaus

 

6 REPLIES 6
lbendlin
Super User
Super User

The Deneb visual has examples of scatter plots with joined dots.

 

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Hi,

thanks you so much for your advice. I now added the table with data. 

 

reg. Klaus

Here's the Deneb version.

lbendlin_0-1686592006112.png

see attached

 

 

 

That look already quiete nice. Thank you so much.

 

There is only one big issue. I could not make a good example of. I need the illustration like this screenshot with different data. You can see the two groups of data in different colors and not connected. 

BHS_KI_0-1686656695326.png

 

Das ist eine komplett andere Situation. Braucht kein Deneb, und keinen Scatterplot.  Siehe Anhang.

 

 

Viel einfacher als ich dachte. Eine Sache der Methodik. Guter Workaround mit der extra Spalte. Das geht dann auch mal manuell. Vielen Dank. 

 

TipTop! 

🙏

 

Viele Grüße aus Sonthofen. 

Klaus

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.