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!
Add Extensible Excel Style "Custom Combo Chart" to Power BI
I would like to suggest the addition of an extensible "Excel Style Combo Chart" feature to Power BI. This feature would allow users to create highly customizable combo charts, similar to those available in Excel. Key functionalities should include: Multiple Series Types: Enable users to add multiple series of any type (e.g., columns, bars, stacked, area, lines, points) within a single chart. Overlay, Order, Opacity: Allow users to overlay different visual types, control the order of series, and adjust the series' opacity to achieve the desired visual effect. Custom Formatting: Provide extensive customization options for each series, including colors, line styles, borders, transparency, markers, and more. This feature would greatly enhance the flexibility and functionality of Power BI visualizations, allowing users to create more complex and informative charts tailored to their specific needs. Indeed, I think if the "Custom Combo Chart" was done well it would eliminate the need to create so many various single purpose charts. Thank you for considering this suggestion.
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
Update line chart with dash-by / shape-by functionality
We've the ability to color (colorby) data series in a line chart using the Legend option in Power BI, but we still don't have the option to "dash by" to determine the shape of the line by another field. This is pretty basic functionality in most of python plotting librires for example. I am trying to port our solution from Dash plotly very hard but limitations like this make using PBI questionable to be frank. What could be an alternative to distinguish the data set based on two “legend” fileds and not on single one? I am proposing an idea to Microsoft to help us differentiate between our data based on another "legend" field.Figma Custom Visual - Possible plugin
Hey there! I've got an exciting idea to share with you all. How about creating a Figma custom visual exclusively for Power BI? Microsoft already has a Figma API for Power Apps, so the groundwork is there. Picture this: we'd seamlessly import Figma wireframes or components right into Power BI with sick UI in PNG or SVG files (if that's doable). And to take things up a notch, let's make sure it supports importing component variants like hover, selected, focused, disabled – you name it – complete with their font and colour hex codes. Trust me, this would be an absolute dream and a total game-changer for designing in Power BI! Let's make it happen, team!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.
