Showing working day no instead of calendar
Hello, i am facing a challenge where i want to have a bar chart showing daily invoiced sales, but instead of showing calendat day no number on x-axis i want to replace it with working day no. Data model setup: Base model: Tabular (storage mode: mixed) tables and dimensions used: 'Calendar'[ID] - linked to transaction table through a many to one relationship 'Calendar'[day no] - this is what i currently use on my x-axis. This is simply showing day number 1-30 depending on the selected fiscal year and fiscal month 'Calendar'[Fiscal Year] - used in dropdown to filter on fiscal year. runs from 1 july - 30 june 'Calendar'[Fiscal Month] - used in dropdown to filter on fiscal month. runs from 1 july - 30 june 'Global Measures'[Invoiced Amount] Requirements: Create a field to the calendar table return Working day no depending on the selected fiscal year and month. Working day counts as monday-friday, weekends is NOT a working day. Also public holidays should also not be taken into account. Working day should start counting from the first weekday of the filtered month and start over when a new month begins. Ideally, when using the field on the visual, weekends should be blank. I have tried to illustrate my idea through the snapshot below. The grey bars represent saturday and sunday to clearly distinct weekdays and weekends. So far i havent been able to find a working solution, so i am trying my luck making a post here. If there is any information needed regarding the data model or relationships etc. i will try to elaborate, just let me know.Create a Matrix that has 3,6,12 month averages of measures
This picture showcases the end goal (sorry i dont have a better example) that i am trying to acheive. I do have a calender table and all the measures but cant seem to find how to achieve this for the matrix visual. Please reach out with any knowldege on this!
Getting a sum of a percentage in my visual instead of an average for the week
Hello, I am trying to get a visual that shows 3 things: Average of % reservation of an office per week, Average of % presence of an office per week, Max % presence of an office within the week. Right now I've been doing the percentage, for both reservation and presence, using a measure. But when I add it to a visual, I get the sum of every % instead of the average of each day in the week. Maybe the method I use isn't the proper one Table Reservation Name Email Office Date John Smith [email protected] A1 10-Oct-24 John Smith [email protected] A1 11-Oct-24 Bob Loblaw [email protected] A3 10-Oct-24 Table Presence Name Email Office Date John Smith [email protected] A1 10-Oct-24 John Smith [email protected] A1 11-Oct-24 Bob Loblaw [email protected] A3 10-Oct-24 Bob Loblaw [email protected] A2 11-Oct-24 Table Reservable Offices Office Reservable A1 TRUE A2 TRUE A3 TRUE A4 FALSE Measures Total amount of reservable office = CALCULATE(COUNT('Total amount of reservable office'[Office]), ('Total amount of reservable office'[Reservable]="True")) %Reservation = CALCULATE((COUNT('Reservation'[Name]))/([Total amount of reservable office])) Can you help out a newby? Also, when I right click on the measure in my Y Axis, I don't see the options to change the agreggation to AVG instead of sum.
create area chart with green and red colors to indicate profit and loss
I have created area chart that that shows profit and loss % over time. I would like to show the loss (negative part) in red color and the profit ( positive part) in geen color. i created 2 measures one for profit % and one for loss % positive p&l = var pl=[p&l %] var result= IF(pl>0 , pl,0) return result negative p&l = var pl=[p&l %] var result= IF(pl<0 , pl,0) return result when i added the measures in the chart it looked like: any idea on how to create the area chart with green/red colors instead of 1 color
DAX Measure not respecting filter context in powerBI visual
Context: In Power BI, I want to create custom labels for my budget values. Currently, I'm using the following DAX measure: label_Budget = VAR BudgetAmount = [Budget_amount_total_no_Scope] RETURN CALCULATE(SWITCH( TRUE(), BudgetAmount > 0 && BudgetAmount < 1000, "€0", BudgetAmount >= 1000 && BudgetAmount < 100000, "€0,.0K", BudgetAmount >= 100000 && BudgetAmount < 1000000, "€0,.K", BudgetAmount >= 1000000, "€0,,.#M") , ALLSELECTED()) My [Budget_amount_total_no_Scope] measure is defined as: Budget_amount_total_no_Scope = SUM(daily_budget) Issue: The issue I'm facing is that the criteria in the label_Budget measure are applied to the total budget values, not per channel. As a result, a channel with a budget less than €1,000,000 gets the same label as a channel with a budget greater than €1,000,000 because the criteria are not applied individually to each channel. Objective: I want to modify my measure so that for every selected hierarchy level, the individual channel values are evaluated against the criteria in label_Budget. Could someone help me adjust this measure so that it correctly applies the criteria at each individual channel level? Any guidance or suggestions would be greatly appreciated.Display Different Measure in based on DAte Columns in stacked Are Chart
Hello Community, I currently have a Stacked Area chart in Power BI which shows two running total Measure Values. In X Axis is a normal Date Table. I also have a constant Line Axis Value which shows the Latest Refresh Date, which is in another Column. The Visual should display the running total values until the latest Refresh Date Constant Line. Afterwards it should DIsplay another MEasure, which is a forecast Value. I tried to use Selectedvalue on the latest refresh date, but did not manage to get proper results
Stop Horizontal line in visual of a running total, when max value is reached
Hello All, I have got a question and de "googled solutions didn't work for me yet. So I've got a linegraph showing a typcial early and late curve. The "Actual line" is shown as a third line, shown in green. Now I would realy like the green line to stop repeating the highest value, however I havent found a working solution yet. the Code behind the green line is as followes: S-curve_Actual_IFR = CALCULATE( COUNTA('IFR_P6'[Actual Finish]), USERELATIONSHIP(IFR_P6[Actual Finish], Datelist[Date]), FILTER( ALLSELECTED('Datelist'[Date]), ISONORAFTER('Datelist'[Date], MAX('Datelist'[Date]), DESC) ) ) Can anybody help me in the right direction? Thanks!How to show total of rows in a table visual under a string column
Hello, I would like to display the number of rows in my table in the total row under a string column. I have created a measure like this: BuildingAndTotal = IF(HASONEVALUE(FactSales[Building]),SELECTEDVALUE(FactSales[Building]),COUNTROWS(FactSales)) But when I use only this measure, the Year column and TotalSales in my table, the detail of the sites disappears. I would like to keep this detail, how to do ? In the Expected table on the screenshot, I have left the Buidling column but I have hidden it. I would like to know if it is possible to have the same result as this table without leaving this column? And I would also like the number of rows to appear as a whole number without the decimals. Is this possible? Thank you for your help, Victor
Column with actual target category date
Hi all, I need your help, i have those tabel as below and I want to show them in one stacked column visual which included monthly view of Target and actual ( in two seperate column next eachother in each month) and with category ( as legend for both). Can anyone hele me?
