Category "powerbi"

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

Power BI embedded report in Angular 7 code is not exported with visual filters applied

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

SSAS TOM - how to access datasource for PowerBI model

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

Hover Over Text in PowerBI

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

Visualization for comparing max,min and avg in power bi

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

SUM VALUES FROM 2 DISTINCT COLUMNS

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

PowerBI Hide 0 Values in the Page | PowerBI

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

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