4,526 questions
0
votes
0
answers
35
views
Elegantly suppressing aggregated data points in a clustered column chart representing fewer than a given 'n' of records
I have a fairly large (long) dataset that looks something like this... one record per individual response to each part of each question:
ID
breakdown_1
breakdown_2
question
question_A_or_B
value
1001
...
-1
votes
0
answers
18
views
DAX Ranking Issue [closed]
I have to create a measure to rank each product within it's category based on total sales. I have used RANK function for this. The first measure (pic 1) correctly achieves that. However, the second ...
2
votes
1
answer
65
views
Enable multi line / wrap of single x axis label text in vega-lite
I have questing regarding Vega-lite in Power BI. I want to wrap the x-axis label after each ; but nothing worked for me.
I was trying:
"labelExpr": "replace(datum.label, /;\\s*/g, '\\n'...
- 23
-3
votes
1
answer
29
views
grouping of items sales price with with qty sold and total sales [closed]
I need help in recreate the report that's done in MS Access in Power BI.
I'm trying to get the quantity sold, total sales amount, etc. by the item sale price that fall into the different ranges.
All ...
- 67
1
vote
0
answers
59
views
Error occured while running DAX in Power BI which is connected to SSAS using live connect mode
I have connected my SSAS with MS Excel and all the dax which i am running is working fine .
Image of DAX result in MS Excel
But when i am connecting the SSAS with Power BI it is not running as ...
1
vote
1
answer
36
views
Filter date using bookmarks PowerBI
I would like to change the date daily by clicking on the arrow.
Selected date should be changed daily by clicking on the arrows. Is this even possible ? many thanks in advance.
I need something more ...
- 3,031
0
votes
2
answers
64
views
Create a calculated column with if statement power query
I have a data as below. I need to create a calculated column in power query. Full name can be consisted of name, last name, middle name and, 2 letters (which should be added in the lastname). Many ...
- 3,031
2
votes
1
answer
75
views
How to allow a visual row to access all rows of a particular column in the visual?
I have a visual using columns from the Timesheets and Users tables, using the relationship on [_userID] (Users-to-Timesheets, one-to-many, single). Each row of the visual is uniquely defined by ...
- 264
0
votes
0
answers
36
views
Measure to average all rows in Power Bi matrix
I want to add a meaure that averages the STORE COUNT column for all rows in attached Power BI matrix.
The STORE COUNT column is a Count summarization in the Values section of the matrix.
I would like ...
0
votes
1
answer
36
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
2
votes
1
answer
73
views
Display all years in PowerBI line diagram
I don't know how the entire universe has evolved to the point of me being alive and having to work with PowerBI and not being able to work this out without asking for help, but here we are:
I have the ...
- 45
0
votes
0
answers
24
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
28
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
2
votes
1
answer
65
views
Issues with DAX measure not showing row values in the table
I have a DAX measure that tries to find the previous weeks target and is used to subtract from the present week target to get me total change. The measure does not show any row values. It worked prior ...
- 31
1
vote
1
answer
73
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