Percent of a value of a row

[Deeper]

Hi all,

I have a table and a row containing values ("Blue", "Red", "Green") and dates

I would like to create a graph with Date by month and percent of Blue vs total of values each month

Date      Blue  Total   

jan 2024  10%   50

feb 2024  15%   60   

Could you help me ?

thanks in advance.

Deeper

[bhanu_gautam]

@Deeper , Share you actual sample data than DAX can be written for this it will be using divide

[Akash_Varuna · Accepted solution]

Hi @Deeper Could you please try these

1. Create Measures:

   • Total Values:
     TotalValues = SUM(Table[Value])
   • Blue Values:
     BlueValues = CALCULATE(SUM(Table[Value]), Table[Color] = "Blue")
   • Blue Percentage:
     BluePercentage = DIVIDE([BlueValues], [TotalValues], 0)

2. Add to Graph:

   • Use a Line and Clustered Column Chart.
   • Drag Date to the X-axis, BluePercentage as the Y-axis , and TotalValues as the columns.

3. Format:

   • Set BluePercentage to percentage format.
   • Adjust the chart to show monthly trends.
     If this post helped please do give a kudos and accept this as a solution
     Thanks In Advance