Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. 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 |
|---|---|
| 44 | |
| 43 | |
| 38 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 67 | |
| 63 | |
| 30 | |
| 30 | |
| 23 |