Category "powerbi"

How to download the report as an excel in the PowerBI

How to download the report as an excel in the PowerBI. Currently, I have embedded the report in the SharePoint page using the PowerBi web part, would need to do

How to use slicer of one table to change a value of slicer in another table in PowerBI

Hi I have two tables(table1 & table2) which both contain year, quarter, month and week. I want to apply a slicer such that when I change the year or Quarter

Combine columns from different tables to make one table Power BI DAX

I have three different tables. I want to select different columns from each of the tables and create one table based on some filters. Have a look at the followi

Transforming data using Python Pandas (or M) in Power Query for PowerBi

I have some data about projects I would like to transform in a way that makes it easier to analyse with PowerBi. The data looks like this: Project Number Proje

Power B.I - create a measure to add rows with "yes" value

I have a column with "Yes" or "No" values in it and I want to count the number of rows with "yes". I can create a new column and have values =1 or 0 depending o

Power BI Show only MTD

I have a problem with the MTD column. I want this column to show only April '22 sales and not the previous months. For example, the sales for April '22 is 7379,

Calculate average across multiple columns in same row across entire table in Power BI

I would like to calculate the daily average weight gain per day for each row and add the answer in a a new column. The variable to calculate the average are

My pages in PBI report is opening on new tab when clicked but I want to restrict this behavior

I have created my application in REACT.js and I have embeded my PBI reports into my application. Whenever I am clicking on the button in my PBI report, I am be

R, Python or Excel. How can I count time range occurrences happening during other time ranges?

Say for example, I want to count how many people are in a room while others are in that room for each day. When that person leaves, I want an updated count of h

power bi: dynamic y-scale values based on data

I'm building a dashboard in power bi and I have a dataset with a few percentages. There are several categories of data, but only one category is shown at a time

Getting 400 bad request in Axios but in Postman status 200

I'm trying to request a Power BI API using axios. var configReportInfos = { method: 'get', url: `https://api.powerbi.com/v1.0/myorg/groups/${process.env

Default slicer selection (latest date) in Power BI

My requirement is when a report will be opened in Power BI services by default, the latest date will be selected in a single select slicer. Consider in import m

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

Hide Blank Columns in a Matrix Visualization or Show Measure Only for Total

I am relatively new to Power BI and have been asked to make some enhancements to an existing report The report is a listing of users with the corresponding num

Throttling settings for a new Graph API endpoint

Power BI (1st party) service will integrate with usageRigths graph API beta endpoint: GET /users/{userId}/usageRights. The API calls will use the existing permi

Tabular Editor - Set "Shared Expression" value from Tabular Editor CLI (with Azure Devops)

I need to change the value of a parameter in a TOM. I am using Azure Devops with steps that include Tabular Editor CLI. I have written a one-line script that sh

Difference between multiple dates in the same column based on category

I have the following problem .. I have this table: I want to create a calculated column that tells me the difference of days between two dates of the same c

Cannot connect Emissions Impact Dashboard to Azure

I am trying to connect my data to the Emissions Impact Dashboard in Power BI. I have an MCA/MPA Azure account and I am trying with a user having Global Admin ro

Excluding null Value from Top 5 Rank but Including in Total

So this is a one I have been cracking my head because I know there has to be a way. I have a Top 10 Country column ranked based on sales. Unfortunately in my da

Power BI: Order data by YearMonth in DAX

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