Category "powerbi-desktop"

PowerBi Distinctcount not working properly with 3 measures

I am having an issue using the Distinctcount function in DAX. I have a table with a total of 1,154,493 rows. I have a measure created to count the number of d

How to create a column based on grouped condition?

My test tabe in powerbi: IdRecord Date Value 1 2022-04-25 23:45:00.000 100 1 2022-04-24 18:07:00.000 344 2 2022-05-01 23:45:00.000 5 2 2022-05-02 18:07:00.000

SnowFlake & PowerBI "native queries aren't support by this value"

Quick Note, I have reviewed these threads and they do not fix my issue: ( Outdated info, see documentation below ) Access Snowflake query results through PowerB

How to assign 1 st, 2 nd,3 rd etc based on number in date filed using power bi DAX formula?

How to assign automatically st/nd/rd/th to number behind in date field using power bi DAX formula. I'm creating labels for date something like this 1st MAY 202

The given key was not present in the dictionary- PowerBI

I'm getting this issue when trying to load/refresh the report, When I clicked the continue the loading wizard starts with an unending state. I am receiving the

Power BI UAT and Regression Testing approach

I am trying to come up with the right strategy on BI Testing (UAT/Regression). Below are the details. Appreciate if you could share you point of view please? Te

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

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

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

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

How to disable visual from being selected but show tooltip on mouseover?

I have a table and a chart visual. When user clicks on table cell or bar chart, the other visuals get filtered/highlighted. I know this can be disabled using th

Dataframe Column name not defined PowerBI Python Integration

i wrote code to visualize matplotlib bar chart using the python Jupiter notebook. But now I wanted to integrate that code with powerBI. That dataset includes 3

Power BI is requiring at least one column to be summarized to display data

I am trying to create a simple Power BI report to embed within an application. The purpose of this report is to simply display the rows that are being passed in