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
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
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
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
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.
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))
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
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
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
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
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
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 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
[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
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
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
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
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 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
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