Microsoft Power BI Community
1,009 FOLLOWERS
Connect, learn and discuss with business intelligence
experts and peers.
Microsoft Power BI Community
2d ago
Hi,
I have used toggle button to switch between bar graphs and line graphs. As soon as I toggle from bar to line the line graphs is changing to vertical dots. Please refer the below images.
  ..read more
Microsoft Power BI Community
2d ago
Hello,
I am trying to buld a matrix that looks more or less like this.
the Total occupied units is a measure that stems from the count of all the units that have 'Yes' in the Occupied column in the [Fact_units] table. The date are stored in theh [Dim_proj] tables.
Projected move ins and move outs are als o measures in another table that counts move ins and move outs.
The total should be given by the occupied units + move ins - move outs. The next week, however should start with the total from the previous week.
In Excel it's easy because I can just point to a coordin ..read more
Microsoft Power BI Community
2d ago
Estoy moviendo mis informes de Excel a Power BI.
Falta formato condicional en la mayoría de los gráficos que he creado en mis informes de Power BI, por lo que tengo diferentes colores por todas partes y diferentes cuando actualizo los datos.
¿Hay alguna forma alternativa de controlar el color de los gráficos?, puedo poner el número #HEX en cada tabla si es necesario ..read more
Microsoft Power BI Community
2d ago
Hola, tengo 3 tablas, como este ejemplo:
la tabla principal tiene una relación de uno a muchos con la Entidad y también con la tabla de País.
Estoy tratando de tener una imagen de tabla como esta:
Tabla visual
identificación
tipo
estado
Entidad
País
1
contrato
Pendiente
Visado
Francia
1
contrato
Pendiente
HTC
España
1
contrato
Pendiente
BFN
El problema es que cuando estoy agregando los campos a la tabla, tan pronto como agrego el campo país, cuando ya tengo la Entidad, recibo el mensaje de error: No se puede determinar la relación entre los campos
Sé que el país Francia o Espa ..read more
Microsoft Power BI Community
2d ago
Hi, I have 3 tables, like this example:
the main table has a one to many relationship with the Entity and also with the Country table.
I am trying to have a table visual something like this:
Visual Table
id
type
status
Entity
Country
1
contract
Pending
Visa
France
1
contract
Pending
HTC
Spain
1
contract
Pending
BFN
The problem is when i am adding the fields to the table, as soon as i add the field country, when i already have the Entity, i receive the error message: Can't determine relationship between fields
I know that the c ..read more
Microsoft Power BI Community
2d ago
Ya tengo configuradas la "Tabla 1" y la "Tabla 2" y necesito usar SUMPRODUCT para derivar la salida y luego usarla en un objeto visual de matriz. La fórmula de SUMPRODUCT es: =SUMPRODUCT($A$2:$A$36, $D$2:$D$36, AA$2:AA$36) / SUMPRODUCT($A$2:$A$36, AA$2:AA$36). Esto resolverá el término "12" en la 'Tabla 2' y será el mismo para cada uno de los otros términos en la Tabla 2 (24, 36) moviendo las búsquedas de columnas en la 'Tabla 2' (AA, AB, AC).
Tabla 1
A B C D
Término
Tarifa base
TLP
Tarifa FTP
1
5.32%
0.17%
5.49%
2
5.33%
0.17%
5.50%
3
5.33%
0.17%
5.50%
4
5.32%
0.17%
5.49%
5
5.32 ..read more
Microsoft Power BI Community
2d ago
Hello,
I currently have a DAX measure that's triggering quite the weird behaviour on the native Matrix visual.
I'm using 4 fields which belong to the same table (Dim_Product) on the Rows and that measure on Values.
The measure is apparently returning the correct values, but it's disabling the Expand/Collapse button functionality of the visual.
Example:
1. This is the state of the visual without any field expansion:
2. This is how it shows itself when I try to expand the first item on the visual using the toggle button:
As you can see above, the button state changes (from [+] to ..read more
Microsoft Power BI Community
2d ago
I already have "Table 1" and "Table 2" setup and I need to use SUMPRODUCT to derive output to then use in a Matrix visual. The SUMPRODUCT formula is: =SUMPRODUCT($A$2:$A$36, $D$2:$D$36, AA$2:AA$36) / SUMPRODUCT($A$2:$A$36, AA$2:AA$36). This will solve for the "12" term in 'Table 2' and will be the same for each of the other terms in Table 2 (24, 36) by moving the column lookups in 'Table 2' (AA, AB, AC).
Table 1
A B C D
Term
Base Rate
TLP
FTP Rate
1
5 ..read more
Microsoft Power BI Community
2d ago
Hola a todos
Estoy tratando de construir un árbol de pérdidas de OEE en powerbi, pero estoy obteniendo el resultado que quiero.
Necesito colocar en un gráfico apilado la parte inferior el resultado de la medida OEE, después de eso las pérdidas de disponibilidad segregadas por sus categorías, y después de eso la pérdida de tasa que es otra medida. El problema es que no puedo colocar la pérdida de disponibilidad en la leyenda si la coloco en el gráfico apilado con las otras medidas. ¿Alguien puede dar algún consejo para mí?
¡Gracias por tu ayuda ..read more
Microsoft Power BI Community
2d ago
Hello, everyone!
I need some help filtering tables that are not directly related.
I have this reference TABLE A - called Items. All my items are there, and the "key" is the Item Number(ArtNr);
Another TABLE B - called Orders, the "key" is also ItemNumber, and I have a visual Table to show me how many pieces per Order Number (OrderNr), based on each Item Number;
Finally, I have a third TABLE C - called Purchase (orders); the key also is ItemNumber as well, but it shows how many Purchase Order Numbers (BestNr) for each Item Number;
The problem is when I filter an Order Number (OrderNr) in ..read more