Generate Power BI Chart with Multiple Levels

Hi Joel,

This is one way to handle your issue:

• We will be: Using Parameters.
• please look at this topic for further details: Line chart with overall total line.
• We added columns: Date and Cantidad to your data

• We added CALCULATED measures to your table, according to the topic referenced above; this is done in the Table View.

Inc. Vales = CALCULATE(SUM(Ejemplo[Cantidad]), Ejemplo[Nivel 3]="Inc Vales")

Incidente de SW = CALCULATE(SUM(Ejemplo[Cantidad]), Ejemplo[CategoriaGrande] = "Incidente de Software")

Incidentes de HW = CALCULATE(SUM(Ejemplo[Cantidad]), Ejemplo[CategoriaGrande] = "Incidente de Hardware")

Incidentes Totales = CALCULATE(SUM(Ejemplo[Cantidad]), Ejemplo[CategoriaGrande]="Incidente de Hardware" || Ejemplo[CategoriaGrande] = "Incidente de Software" )

Commandas = CALCULATE(SUM(Ejemplo[Cantidad]), Ejemplo[Nivel 3]="Commandas")

• In the Report View, we added a New Parameter.

Parameter = {
    ("Incidente de SW", NAMEOF('Ejemplo'[Incidente de SW]), 0),
    ("Incidentes de HW", NAMEOF('Ejemplo'[Incidentes de HW]), 1),
    ("Inc Vales", NAMEOF('Ejemplo'[Inc. Vales]),2),
    ("Commandas", NAMEOF([Commandas]),3),
    ("Incidentes Total", NAMEOF([Incidentes Totales]), 4)
}

• In the Report View, we added a Line Chart with the following visualizations attributes:

• This is the Line Chart with parameters as described:

Comments:

• You did not supply sample data and some of the columns are missing, I added my sample data, and it is very difficult to illustrate a solution with incomplete data.
• You did not define your Incidentes Total expression, this solution is using Incidentes de SW and Incidentes de HW.
• Your expected solutions combined data from 3 different categories, two of them easily converted to a combined one (Nivel 1 + Nivel 2).

Hope this helps,

Arnaldo.