Questions tagged [powerbi-desktop]

Power BI Desktop is the desktop application for Power BI, a free, self-service analytics tool.

3559 questions
0
votes
1 answer

Extract latest value from each row in a column

I am trying to create a DAX calculated column that only shows the new value added in the row. My data is collected in where for each new entry a new row is created where an entry is appended either at the start of the string or at the end. This…
Steve_Greenwood
  • 546
  • 8
  • 20
0
votes
0 answers

dynamic kusto query in powerbi - getting error saying that query isn't supported in DirectQuery

I'm using powerbi and want to let the user select a parameter in the dashboard (date in my case) and pass the value to a kusto query I'm running. I read a lot about it, to name a…
Ofek Agmon
  • 5,040
  • 14
  • 57
  • 101
0
votes
0 answers

Views or Tables in Power BI

This is a fundamental architecture question for Power BI. I have developed star schemas for years and now my job is wanting me to go into the UI world as well. I want to start off correctly, so I was wondering if I should create views and import…
0
votes
1 answer

Conditional Formatting when condition is met on two columns

Within Power BI I have two columns, one that contains Yes or No and the other a Date Column. What I am looking for is for when the answer in Column 1 is No and is older than two days then highlight as Red (similar to what can be done in excel) I…
Sc0719
  • 73
  • 10
0
votes
1 answer

Power BI is missing Google Sheet connector

Power BI provides the Google Sheet connector which is no more in Beta version and should be available on any lates Power BI version. On my laptop I'm running the version 2.114.664.0 64-bit (February 2023) and I have updated Power BI also on the same…
0
votes
1 answer

How to exclude specific columns in a matrix visual?

I'm trying to build a matrix visual which shows the Product code (sku) and the quantity sold in the last 30 days, 60 days and 90 days (Aantal verkocht in laatste xx dagen). Now I want to also add the supplier(leverancier) to the corresponding…
MrRose
  • 1
  • 1
0
votes
1 answer

How to set location based in country name when latitude and longitude is 0 (null)

For example, I have some fields with 0 for latitude and longitude. This happen because in the database, those columns are null (longitude and latitude is unknown). How can I simply set the country name for latitude and longitude 0? (in this case,…
Potter
  • 434
  • 8
  • 21
0
votes
1 answer

Can slicers be used a stored procedure parameter in power bi to filter underlying data

Can we pass the slicer values as stored procedure paramter when connecting to a sql for developing a PowerBI report so that once its deployed in powerbi service the end user can use slicer to filter the report I tried to use a stored procedure …
0
votes
0 answers

Power BI Desktop: Sizing Matrix Visual to A4 Page

I have created a matrix visual in Power BI Desktop and I need to fit it to an A4 PDF Page (landscape format). Unfortunately the matrix is quite big, so I have to scroll vertically and horizontally to view the whole matrix visual and when I export to…
AzUser1
  • 183
  • 1
  • 14
0
votes
0 answers

How to enter parameters into power BI template pbit file and then letting those load before next dynamic parameter is selected

I have four parameters that are required in a pbit powerBI template for the report to load. However, the fourth parameter(org_ids) is a dynamic dropdown parameter that needs the first three parameters to refresh and get the list of values that will…
0
votes
0 answers

Can a guest user refresh a dataset in Power BI?

Can an invited guest user(external user) refresh a dataset in Power BI ? I am facing an issue with Scheduled refresh for Scorecard/Goal Dataset for an Invited/External user. It is always throwing an error. Can anyone please help ? I went through the…
0
votes
0 answers

Is there a way to show map from Python in powerbi?

I am trying to show a map of rail lines on powerbi. The map html was generated from the python library folium. Is there a way to show it on powerbi?
helpme
  • 163
  • 3
  • 9
0
votes
1 answer

How do I correctly use report-level filters in Power BI?

I am fairly new to Power BI and working on my first project. I currently have two separate sql views setup and connected to my project as well as a simple visual for each one. They both share a common field that I want to filter on, call it…
Migals
  • 1
  • 2
0
votes
0 answers

Measure Table preventing refresh. Stuck on 'Creating Connection in model'

I'm trying to refresh locally on Power BI Desktop. I have a few measure folders. All of the data tables has been refreshed. However, the measure tables (a table with nothing but dax measures in it), are preventing the refresh from completing. They…
zach
  • 759
  • 1
  • 9
  • 21
0
votes
0 answers

How to Save user slicer selection on powerBI

I need one help, I have one powerBi report which contains 5 slicers on this. so I want when user select any slier that time this selection need to save and when next time user open this report, earlier selected slicer need to set and open the…
NitinK
  • 1
1 2 3
99
100