Forum Discussion

Phil88's avatar
Phil88
New Member
1 year ago
Solved

Normalize data ranges for Line Chart

Hi all,   i have four monetary datasets A B C D on a timeline that range between some thousands to millions and want to bring them together in a single line chart just to see the trends. By default...
Need Help
  • Rupak_bi's avatar
    Rupak_bi
    1 year ago

    Hi Phil88 ,

    Thanks for sharing the sample file. This helped me to understand my mistake. please modify the measure as below

    Linie_A = 
var min_val = calculate(min(Tabelle[A]),allselected(Tabelle[Datum]))
var max_val = calculate(max(Tabelle[A]),allselected(Tabelle[Datum]))
var current_val = max(Tabelle[A])
var factor = 100/(max_val - min_val)
return
(current_val-min_val)*factor

    Please refer the last graph .

     

    If this solves,  Plz accept as solution

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Phil88 ,
Thanks for reaching out to the Microsoft fabric community forum.


Try Min-Max Normalization by Measure and Time

This technique rescales each dataset (A, B, C, D) to a range of 0 to 1 over the selected time window

Create a Normalized Measure for Each
A_Normalized =
VAR MinA = CALCULATE(MIN('Data'[A]), ALLSELECTED('Data'))
VAR MaxA = CALCULATE(MAX('Data'[A]), ALLSELECTED('Data'))
RETURN
DIVIDE('Data'[A] - MinA, MaxA - MinA)

Repeat similarly for B, C, and D.

Then After :
Use a unpivoted format (e.g., columns: Date, MeasureName, Value, NormalizedValues) in your data model.Use NormalizedValue as your Y-axis in the line chart, and Measure Name as legend.Add a tooltip or use Tooltips page to show the original value on hover.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team