20,652 questions
0
votes
0
answers
29
views
How to prevent jumpback on user input in deneb vega gantt chart?
I am trying to create a Vega Gantt Chart using the template from David Bacci - Deneb-Showcase.
In my original dataset I am taking the data from sharepoint and importing it into deneb visual. I did ...
- 25
0
votes
1
answer
41
views
How to update a Power BI Template
Months ago I have downloaded the:
Microsoft Fabric Capacity
Microsoft Fabric Chargeback Reporting
The version I have are the following:
It seems to me that I have a discrepancy between my version ...
- 12.8k
0
votes
0
answers
30
views
Azure DevOps Analytics Not Showing Full Iteration Path
I am trying to create an Azure DO Analytic that I can bring into Power BI. Specifically I am trying to get all PBIs for the current sprint. When I pull up a PBI from the sprint the iteration path is:
...
0
votes
0
answers
39
views
Set custom colors for legends in stacked column chart
I have a stacked column chart and I want custom color for each brand present in the data. The brands are added in the legends section. I could go and set color manually for each individual brand but ...
- 39
0
votes
1
answer
39
views
How to show latest date first (descending order) in Power BI Matrix column headers?
I am building a Power BI dashboard where my Matrix visual has employees in rows and dates in the column headers.
The date field I am using is:
Hours_Provided_by_Manager_ScriptOutput_AMOps[...
- 11
0
votes
0
answers
31
views
How to align multiple tables and create dynamic last 3 months columns when migrating from Tableau
I am trying to migrate a Tableau dashboard to Power BI, and I’m having difficulty building the tables in the desired format.
I currently have 3 separate tables:
Matrix table – showing Classroom, ...
- 29
0
votes
0
answers
50
views
Creating a drillthrough button in power bi where selecting a category is optional
We have created a PowerBI report with a overview page that gives the users an overview over the key insights in the report. In this overview page we created a section which basically shows the actions ...
- 1
0
votes
0
answers
30
views
Save daily report to historical data set using FillDown in Power BI
I receive an Excel file, usually daily, that is used to display the current situation, but I want to take a summary of that data and add it to an historical file to show the performance over time. The ...
- 81
0
votes
0
answers
36
views
send powerbi table via email to team managers
I have created a powerbi table as below. Using Power Automate, I would like to send an email to team managers so they can see only their team members only. Something more complex than this. Many ...
- 3,031
0
votes
1
answer
53
views
Last 7 days average in Power BI
I wanted to get the last seven days of my sales based on the slicer selection. I have a Slicer which has 2years of dates. If I select any date in the slicer I need to visualize the 7 days of my sales %...
- 95
0
votes
0
answers
28
views
Power BI Report Builder (SSRS), Filter the contents of a table using the contents of another table, filtered by parameters?
I am trying to define a parametric report using program data. In my Power BI model, this is easily resolved using relationships between the tables, and I am trying to recreate that same amount of ...
- 13
0
votes
0
answers
71
views
Query a Dataset in Power Automate Not Returning Expected Results
I am trying to run a query against a dataset from PowerBI Semantic Model in Power Automate to return a CSV file with the outputs.
Steps I have taken:
Created a Power BI Desktop file that connects to ...
- 15
0
votes
0
answers
49
views
Is it possible to connect a PowerBI report to an Excel file using a Virtual Network Data Gateway?
We are in the process of replacing an On-Premises Data Gateway running on a VM with a Virtual Network Data Gateway running in Azure; the VNet Data Gateway has full connectivity and name resolution to ...
- 1,550
1
vote
0
answers
42
views
How to show both count and total price with Date Slicer?
I’m working on a Power BI report and using a Sankey diagram with ChartExpo Sankey, Visio Chart Sankey, and Microsoft Sankey (from AppSource).
I want the Sankey to display both the count of items and ...
- 11
0
votes
1
answer
41
views
Reporting m to n Jira issue types
My problem is an m to n relationship between the issue types "Epic", "Story" and "Bug". So a Bug can be a child of a Story, or a child of an Epic. But in some cases it is ...
- 1
1
vote
1
answer
80
views
Filter table by Last entry per day per ID
I have a table which has an entry for every time a ticket is assigned to an agent or team. What I need to be able to do is find latest datetime for each faultid per day. Table is similar to below
...
- 13
0
votes
1
answer
69
views
How can I create a multi-slice slicer in Power BI?
I have created 2 tables:
table1 = GENERATESERIES(1, 10, 1)
table2 = GENERATESERIES(2, 20, 2)
I want them to appear using the same Slicer visualisation such that:
I have tried:
Table = DISTINCT(UNION(...
- 67
0
votes
0
answers
29
views
How to drilldown PowerBi between two different Fact table
Hi i wounder how i get drilldown from one subject with one special point to see the points fragment of that point in the main table.
On this image i want to right click on the 2 point from (Betyg) and ...
- 93
0
votes
0
answers
23
views
Power BI - SPC Custom Formatting
I've installed the SPC custom visual created by the government of western Australia and I'm attempting to reformat certain aspects of it via importing a JSON file. See below.
{
"name": &...
- 13
0
votes
0
answers
50
views
Get budget group by project with aggregate budget and task dax
I am working in a project with power BI and DAX but it seems not working right for me.
I have a first table vproject that contains multiple projects and each one have multiple tasks with multiple ...
3
votes
2
answers
132
views
How to join two tables when one table has filters to applied to the second one?
I have these two tables:
+-------------------+ +-------------------+
| TAB1 | | TAB2 |
+---------+---------+ +---------+---------+
| PRODUCT | ACCOUNT | | GR | ...
- 31
3
votes
1
answer
49
views
How to create measure to get last salesperson to sell a product with date slicer altering filtering the sales transactions?
Given I have a products table and sales table as below;
Product ID
Product
1
Roller Skates
2
Bicycle
3
Monitor
4
Keyboard
ID
Product ID
Sales Person
Dated
1
2
Peter
2025-03-12
2
1
Brian
2025-03-14
3
2
...
- 93
1
vote
1
answer
86
views
Problem when trying to sort a column by another column
I'm working on a product table where I have several classification levels for each product: “Classification 1” (Beds, Box Springs) and “Classification 2” (King, Queen).
I have a visualization showing ...
- 17
1
vote
1
answer
77
views
User Powershell to get Power BI Paginated Report Parameter Names
I have a need to know what parameter names are required for each paginated report -- the actual names, not what is displayed to the user -- but I don't want to open Power BI Report Builder for every ...
- 3,163
1
vote
1
answer
149
views
Why can we not use measure like this in PowerBI?
My table sheet is
Region
Value
First
1
Second
2
First
3
Measure 3 = CALCULATE(COUNTROWS(Sheet),Sheet[value]<[Measure])
Measure = MAX(Sheet[value])
Why can I not write [Measure] like this? I get ...
- 61