I would like to create a YearMonth column in Power BI and group data in this order in visual plot, say histogram. I tried to create a duplicate of the datetime
We have embedded Power BI report in Angular 7 code and when we try to export using Power BI provided service it is not exporting applied filters instead it down
I'm using TOM to interrogate and manipulate a PBIX file open in Power BI. The PBIX file uses a parameter to set the connection string to the sql database that
Wondering if there's a way to make a text bubble show up when the user hovers over a metric in a Power BI report. I have tried using alt text, but that does no
I want to show comparing of these value in line chart : max-min and average(actual value) Assuming we have these three values without thinking to the data struc
Hello, people. As you guys can see on the table above, I´have more than one "seller" per "order_num" and it’s ok. But I need to SUM the "sku_qtd" w
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
elasticsearch-analyzers