We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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.
@Syndicate_Admin , if you are using two measures, you should use them two y-axis. One line on each Y-axis- Primary and seconday
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 38 | |
| 33 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 67 | |
| 62 | |
| 38 | |
| 34 | |
| 22 |