Power BI Desktop is the desktop application for Power BI, a free, self-service analytics tool.
Questions tagged [powerbi-desktop]
3559 questions
4
votes
1 answer
DAX Measure: dynamically consider only first for each group and and overall returns their count
We are struggling in trying to solve a problem that might simpler than I think. I am just stuck.
The problem consists of defining a DAX Measure that dynamically counts only first visits in the period for each patient. Visits that are not first in…

Seymour
- 3,104
- 2
- 22
- 46
4
votes
1 answer
How to calculate Percentage out of Total value in DAX (Power BI Desktop)
I have the following Slicer in Power BI Desktop, where # of Clients is calculated as Count(Distinct(Fact.EHRTransaction.ClientFK)) in my data model:
My goal is to calculate Percentage out of Total (13 639) and add it to this slicer as a Measure or…

Hell-1931
- 489
- 1
- 6
- 24
4
votes
3 answers
Apply timezone by id on Power BI
(Here's quite the same question I opened on Microsoft Power BI community forum)
I have a table in my database where I have a column with datetime values in UTC and another column with the timezone of this datetime (a string containing the IANA id of…

Leo von Barbarosa
- 727
- 8
- 22
4
votes
1 answer
Unable to generate embed token for accessing dataset due to missing roles in effective identity
I have embedded powerbi report which was working fine until I changed my database.
I observed datasets.IsEffectiveIdentityRequired (in below code) was false earlier, now as it is true, I'm getting an error -…

sajid irfan
- 337
- 4
- 11
4
votes
1 answer
Status code: 416, description: 'The range specified is invalid for the current size of the resource.'
Status code: 416, description: 'The range specified is invalid for the current size of the resource.'. I am getting the above eror while load the data from azure blob storage. can any one help me out.

Siva Bommana
- 37
- 5
4
votes
1 answer
PowerBI Desktop and R Error: package or namespace load failed for 'ggplot2'
I'm really stuck and need some help.
After installing R 3.5.1, I'm getting this error message on R visualizations in Power BI Desktop which were previously working
"Error: package or namespace load failed for 'ggplot2': package
'scales' was…

Bruno Cruz
- 65
- 9
4
votes
2 answers
How to fill out blanks in Running Total matrix Power BI
I am working on Loss Triangle in Power BI where AccidentYear are rows and DevYear are columns.
The values in the table are Running Total created by measure:
Running Total Loss =
CALCULATE(
SUM(fact_Losses[PaymentAmount]),
…

Serdia
- 4,242
- 22
- 86
- 159
4
votes
3 answers
Power BI Filter on MAX of a column
My data has a column with the week number. I want a visual (graph in this case) to show the latest week which is the MAX of that value. The visual filter doesn't appear to let me put in the MAX of something, just the usual greater than, less than…

tonyyeb
- 719
- 5
- 13
- 32
4
votes
3 answers
Power BI workspace limits
How many reports can I create in one power bi workspace ?
How many datasources can I create over there ?
Details:
We are going to implement our own application and use Power BI Embedded features. Our app will own all data, thus our users will be…

Alezis
- 2,659
- 3
- 27
- 34
4
votes
1 answer
Show time duration as "hh:mm:ss" in PowerBI charts
I am working with PowerBI and would like to show time duration in the format "hh:mm:ss".
I know how to convert duration (seconds, minutes, hours etc.) into a string in the format "hh:mm:ss" using DAX, but is it possible to get this format as labels…

john
- 395
- 2
- 4
- 13
4
votes
2 answers
One Slicer for Power BI Desktop affecting multiple tables
I'm setting up multiple tables on a single Page in Power BI Desktop, with plans to publish to an App. I'm using SQL Server as a data source to pull the output of three different pre-established System Views. Each of the Views pulls from the same set…

David Martin
- 95
- 1
- 2
- 9
4
votes
2 answers
Power BI | Creating calculated column from date type column in YYYY Q format. E.g., 2018 Q3
We have a date column and I would like to create a new column in Power BI in YYYY Q(quarter number) format.
For example, if the date is 11/21/2017 then the new column should store 2017 Q4.
Later we would like to use the newly calculated column as a…

Sid
- 199
- 1
- 10
4
votes
2 answers
How to show missing dates on PowerBI Clustered Column Chart
I have a data set which has incidents resolved w.r.t date. I would like to look at the trends of number of incidents resolved over the past 45 days only on a Clustered column chart.
I couldn't see entries for specific dates (because the number of…

Ajay
- 41
- 1
- 4
3
votes
1 answer
How can I calculate earned premium in Power BI using DAX?
Calculating Earned premium with Power BI.
Hello, i am pretty new to Power BI and i am very stuck on the calculation for Earned premium with power bi for my project. I have tried to look up solutions online but for some reason they just would not…

kao-hsu Lin
- 31
- 1
3
votes
0 answers
How to auto group monthly data (Stacked column chart) in Power BI presentation
Currently, we created the Power BI report with Excel source and update everyday with incremental changes in DB. I have Bar chart which represents monthly data, using Group option to show data month wise. With this method, I need to alter the…

SPT
- 139
- 1
- 6