Поддержка Power BI
Поиск
Showing only names with 1 ID
Hi there, I have a list of Agent Names and their Commission type. An Agent can have just commission type 1 OR BOTH 1 and 2 (if they have 2, then they have 1) I'm trying to isolate only th...
Mostrar solo nombres con 1 ID
Hola Tengo una lista de nombres de agentes y su tipo de comisión. Un agente puede tener solo el tipo de comisión 1 O AMBOS 1 y 2 (si tienen 2, entonces tienen 1) Estoy tratando de aislar solo ...
Re: Fetching data sources from dataset using PowerShell script
I am using both App registration and my credentials but getting same results. App registration have Power BI admin access and added as an admin of all workspaces in premium capacity. Yes i allow...
Re: Get a Slicer to Show Total Sales Per Product
I finally solved it. 1) Create a calculated table. The first column's formula is: units sold calc = CALCULATETABLE(DISTINCT(Sales[ProductID])) 2) In the Model View, the column "Pro...
Re: How can we change the background color like this in line chart on PowerBI?
I don't believe this is possible. If the graph is very static and the X axis never changes, you could add a background in plot area background as a workaround, that is devided in 4 sections (assuming...
Re: Custom column to find out in days/hours, how long it took between Created and Assigned on
I had a typo and once I fixed that, your code worked. Thank you!
Re: Dax Measures from Datamart available with SQLEndpoint + Import
Thank you and you are correct. Do you know of any workaround to make the measures available?
Re: No Filter Contex after Transforming Table in Power Query for Frequency Distribution
Hi, Why have you create multiple table. There should be just one unpivoted table.
Re: Bug: Table.ReplaceValue kills all column types
It's now been over six years since this was reported. Still exists in Excel and Power BI desktop. I wonder if it will ever be fixed. Unfortunately, as he pointed out, @Brian_Hayes ...
Re: General Setup Help
Hi, Would you be OK with the slicer showing percentage groupings i.e. 0%-5%, 6%-10% and so on, rather than single scalar values (which could also be many)? If yes, then share theese buckets a...
Re: Beginner needs help creating Matrix or Table Showing Previous Week Tickets vs Current Week
Share the download link of the PBI file.
Re: Cómo crear una columna calculada y ponerla en la leyenda
Hola Se adjunta archivo PBI. Espero que esto ayude.
Re: Time Tracking - Hours and Minutes between dates
H @PBI_Rookie_19 , You can create a calculated column to get the difference between two timestamps and then format it as hh:mm:ss. A simple endcolumn - startcolumn shoul do. ...
Re: Datamart "download Excel File" button not working
Same issue experienced here and would really like to know when this issue will be resolved. This solution would be fantastic for a few uses cases I'm addressing, but the lack of this feature is...
Re: Average formula
I need an average of both the sheets
Re: No Filter Contex after Transforming Table in Power Query for Frequency Distribution
hi, thanks for your response. because i need the origin table like it is. the child referenes tables are only there for a visual to show the distribution of the answears in a specifition column. &n...
¿Necesita ayuda del concepto de asignación en Power BI?
Hii Power BI Community, Espero que a todos les vaya bien y gracias por el avance, Necesito ayuda con mi requisito en Power BI, En lo anterior, tenemos la vista del estado, la vis...
Unique Person Count Overlapping Venn Diagram across services
Hi there, At the early stage of thinking this through, so maybe I don't need a full solution but being pointed in the right direction. One of my organisations top KPIs is the count ...
Re: Remove HTML Tags from Column with Null Values
' try Html.Table([Column] , {{"text",":root"}}) otherwise null '
Re: Eliminar etiquetas HTML de la columna con valores nulos
' try Html.Table([Column] , {{"text",":root"}}) de lo contrario null '
Re: Transforming data help
let Source = your_data, g = Table.Group(Source, "Name", {{"rows", each {[Name]{0}} & [Policy]}}), to_tbl = Table.FromList(g[rows], (x) => x, List.Count(List.Max(g[rows], null, List...
hola
Hola ¿Alguien puede ayudarme a corregir este error? VAR _sel = SELECTEDVALUE('Comparaciones de KPI'[Campos de comparación de KPI]) VAR _var = INTERRUPTOR( TRUE(), CONTAINSSTR...
Re: Major Problem with DAX Time Intelligence Functions such as TOTALYTD etc.
@maitydd64 You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000 Also, see if my Time Intelligence the Hard Way provides a d...
Recuento distinto para varias columnas
Hola equipo de la comunidad de BI, Tengo una tabla de pedidos de ventas que contiene el código de cliente y SKU. Para aplicar el recuento distinto de 02 estas columnas, necesito crear la nueva co...
Re: Parameter PBi
The problem is I do not have a create button on the parameter dialog box in power bi, when you say you can create a parameter in power query via transorm, create a parameter and yes back...