Category "powerbi"

PowerBI Hide 0 Values in the Page | PowerBI

Could someone advice how could be hide 0 values from all chars on the PowerBI page? For example when I clicking on chart A and want to filter just specific Axi

Is there a way to add line breaks in a string of text in M (Power BI)?

I concatenated four columns using this code (to prevent null values to be linked together) in Power Query (Power BI Desktop): = Text.Combine(List.Select( { [Col

Power BI - Unpivot a few columns in a table without interfere the remains columns

So I have this table: Original Table I would like to transform the Defect columns into only one without affecting the total of the Inspected column. I've tried

Azure Devops Dashboards - How to chart the trend of query results over time based on work item history?

I want to be able to generate a stacked bar chart based on the results of a query, for example the number of open bugs and open features. I would like to see th

Row number partition by to POWER BI DAX query

Can someone help me to convert the sql string to Dax? row_number() p over (partition by date, customer, type order by day) The row number is my desired output.

Tabular Editor: How to use advanced scritpting to create multiple measures based on one value and one category column

I am trying to create multiple measures in Power BI through advanced scripting in Tabular editor that would replicate a Calculate(Sum(ColA),Keepfilters(ColB=i))

How can I add a column with find the closest date found in a second table using dax or m?

I have two tables. One with dates of tech support given, and the other one with surveys sent to the customers. The problem is that the surveys are sent some day

Sort column circular dependency in Power BI

I have to sort month name from January to December in Power BI Desktop. Power BI sorts the column according to the alphabetical order. Here is my dataset: When

Power BI : filter on a rank

I have calculated ranked using this formula which worked perfectly well : RANK = RANKX(ALL(td_store[LIB_MAG]), CALCULATE(SUM(tf_market_share_by_store_nomcenclat

How can I get total amount value for each different user in PowerBI

I want sum all 308 values in userprofileid column to get the total amount of the values for that user in the amount column This image shows GROUPBY(userprofile

PowerBI - getting EmbedToken - Unauthorized

I have been trying WITH NO LUCK, to get an embed token to be able to embed my powerbi reports into my existing .netcore web api application. The front end look

Get the max date value for each user in PowerBI

I can't get the MAX date value for each user in PowerBI. For example, in this image for userprofile 170 I want 09/12/2020 value because is the maximum value fo

How to count rows in a table, where a specific column value is in a list of specified values?

How do I create a DAX measure to count the number of customers in a customer table dCustomers, where the customerType is either FR, DE or GG? In SQL, this would

what kind of measure or column will use here

[Please refer to the below image. I want to create a stacked column chart but I don't have a column that includes 0-30, 30-60, 60-90, etc. How did I put this ra

Can we export PDF and PPT of an embedded Power BI report by calling an the Export feature of the Power BI Service/Workspace

We have an embedded Power BI Report and we wish to have an export functionality in the website which calls the export option that is present in the top bar in t

Pywinauto - There are 2 elements that match criteria

this is my first post! I would like to ask you how can i solve this problem. I am trying to automate publish in powerBI. I need to click on correct workspace. R

How convert "blank" to 0 in a card in Power BI with live connection with analysis services?

i have a dashboard in power bi that take data from analysis services. The problem is that can't show a 0 in a card when there aren't values for this filter. in

Is there a way to direct query Salesforce Objects to Power Query/Power BI without having to extract the object

My data lives in Salesforce objects and I am trying to connect Power Query to Salesforce Objects. The limitation here is that I have to extract the whole object

How to extend powerBI token Id expiry time

How do I change the token Expiry time in power Bi? Steps followed to generate token: Registered power Bi App After providing the details got the client id and

Power BI: Plot not showing complete data

I am using a ribbon chart to visualise total sales over 3 years, using Product ID as legend. Then in another bar graph I plotted total sales by Product ID. What