Questions tagged [powerbi]
Power BI is a free, self-service analytics tool available individually or integrated with Microsoft Excel, Office 365 and many major databases and analytics tools.
powerbi
20,425
questions
3
votes
1
answer
24
views
Ignoring error in Table.ExpandTableColumn or auto-replace with null
I am loading 100s of XML files from a folder and Power Query has created a function from the first file I had loaded. The problem is not all the XML files have a similar structure. Some have nodes ...
1
vote
0
answers
13
views
DAX studio not showing as external tool in Power BI desktop
I installed Power BI desktop and DAX studio. DAX studio generated a file in C:\Program Files (x86)\Common Files\Microsoft Shared\Power BI Desktop\External Tools folder named daxstudio.pbitool.json ...
0
votes
0
answers
16
views
How to define measures automatically via PowerBi custom connector
We are planning to build a PowerBI custom connector for our product. The backend would be mostly responding with csv / json tabular data, however this data may require some special interpretation at ...
0
votes
0
answers
26
views
Power BI DAX Function
enter image description here This is my data in Yardi.
Rank represents unique line no. for each GL code.
enter image description here This is the matrix I created.
Now I want to calculate % which has ...
0
votes
0
answers
6
views
Navigate from matrix to table and show the data based on select done from matrix
I have a matrix with column A and column B in rows, column C and column D in values. I have 2nd table contains data linked with column A.I am not able to figure out how can I show the data from table ...
0
votes
0
answers
8
views
Clear previous value selected PowerBI slicer on change from another slicer
I've 3 slicer in powerbi for referenceId, lower version, higher version.
On selecting reference id I see some versions value available in other two slicer. I've un linked the versions slicer from ...
1
vote
1
answer
24
views
Difference between FILTER function and CALCULATE function in PowerBi
Is FILTER function is an extended version of CALCULATE function ?
I am learning PowerBi and just curious to know the difference between them. I think there is not much difference between them. Filter ...
0
votes
1
answer
48
views
How to generate token access Power BI
I am using OAuth to generate bearer token.
The generated token includes "https://analysis.windows.net/powerbi/api" as audience.
But it reports Unauthorized calling Power BI API.
GET https:/...
0
votes
0
answers
12
views
Power BI: Ribbon Chart changed by Slicer
I’m new to Power BI.
I have a table like this:
Type
Food
Hygiene
NFI
City
1
2
1
City
3
1
1
Village
1
1
2
City
2
2
1
Village
1
3
1
City
3
3
2
I want to have a Ribbon chart with:
Ribbons (Legend)...
0
votes
0
answers
6
views
getSlicerState() is not working for SelectAll option
We are facing issue when using Power BI API getSlicerState().
When we select "Select All" value in the slicer it returns us an error.
Below is the screenshot depicting the same.
enter image ...
-2
votes
0
answers
11
views
Dynamic ABC analytics in Power BI [closed]
Can someone explain how does this DAX code work?
ABC Sales Amount =
VAR SalesByProduct =
CALCULATETABLE (
ADDCOLUMNS (
SUMMARIZE (Sheet1, 'Sheet1'[Артикул]),
"@ProdSales", [Sales Amount]
),
...
0
votes
1
answer
24
views
Vega via Deneb in Power BI sankey chart grouped source and target names
I d like to create a sankey chart chart using vega in Deneb. I found an article online and I have the following code, but I would like to show the countries grouped
currently my result is like this, ...
-2
votes
0
answers
11
views
Is there a visual calculation to get the value from the left column?
I have a matrix visual.
The row is Customer.
The column is FiscalYr.
The value is TotalSales.
I want to show the year over year difference. That is - current year sales minus previous year sales.
Is ...
1
vote
1
answer
27
views
How to count results after advanced filtering
enter image description here
When i selected the advanced filtering, this statistic has not changed and still shows the total number.
Filtered Records = CALCULATE(COUNTROWS(TableItems))
It updates ...
0
votes
0
answers
15
views
Change PowerBI Data Source Server without Refreshing Report in PBI Desktop
I have a large number of PowerBI reports where the Source Server and DB is "ServerA.Database1". I have setup data replication so that the tables necessary for reporting are now available in &...