Forum Discussion
Syndicate_Admin
2 years agoAdministrator
Convert Matrix to Line Chart
Hello
I have the following matrix that I take from this measurement:
Medidas matriz almacen =
VAR calc = IF(SELECTEDVALUE(matriz_entradas_almacen[nombre])="Albert" && SELECTEDVALUE(matriz_entradas_almacen[descripcion])="Entradas",FORMAT(CALCULATE([PickingEntradas],Cab_act_almacen_reg_sql[Cod_ operario almacen]=6),"General Number"),IF(SELECTEDVALUE(matriz_entradas_almacen[nombre])="Albert" && SELECTEDVALUE(matriz_entradas_almacen[descripcion])="%",FORMAT(DIVIDE(CALCULATE([PickingEntradas],Cab_act_almacen_reg_sql[Cod_ operario almacen]=6),CALCULATE([PickingEntradas],REMOVEFILTERS(matriz_entradas_almacen))),"Percent"),IF(SELECTEDVALUE(matriz_entradas_almacen[nombre])="Iván" && SELECTEDVALUE(matriz_entradas_almacen[descripcion])="Entradas",FORMAT(CALCULATE([PickingEntradas],Cab_act_almacen_reg_sql[Cod_ operario almacen]=2),"General Number"),IF(SELECTEDVALUE(matriz_entradas_almacen[nombre])="Iván" && SELECTEDVALUE(matriz_entradas_almacen[descripcion])="%",FORMAT(DIVIDE(CALCULATE([PickingEntradas],Cab_act_almacen_reg_sql[Cod_ operario almacen]=2),CALCULATE([PickingEntradas],REMOVEFILTERS(matriz_entradas_almacen))),"Percent"))))
Return
calc
Table matriz_entradas_almacen is an isolated table that has no relation to any other table.
Now what I would like is the same but with a line graph but what it does to me is different. In fact, as you can see in the image, it only takes the values of three "operators" but not the rest as it does in the matrix. I imagine that the above measurement that I use for matrix is not useful for graph.
Can you help me?
Thank you.
1 Reply
- amitchandakSuper User
Syndicate_Admin , if you are using two measures, you should use them two y-axis. One line on each Y-axis- Primary and seconday