User Profile
BarryWhitelaw
Regular Visitor
Joined 1 year ago
User Widgets
Contributions
Re: Filter By a List
Hi there The filters are generally the same fields each time, Account, Start Date, End Date. As per my previous reply, I did eventually work out how to do this by adding a New Table and amending the code to read as below. This created a filtered set of data, which seems to work perfectly 🙂 thanks for you reply BarryRe: Filter By a List
Hi there and thanks for your reply. After some investigation I managed to find that I could use a dax formula, which created a 2nd data table already filtered. This means I can build all my visuals without having to add extra filtering. It may not be the neatest way of doing it but it works. I created new table then amended the formula to: I can't take credit from it, Copilot eventually supplied this after much varied prompting. BarryRe: Add Row Showing % of Current Column
Hi there, and thank you for your reply. I'm lost with the first part of your suggestion, update my measure. Currently I am using a matrix table and literally using 3 fields from my data in it, so no measure was created. Is that was I should be doing, and where in the measure would I add your formula?Add Row Showing % of Current Column
I'm writing a visualization that shows Months, Region and Spend. I need a row underneath each month that shows the % of spend against the total. When I add a New Visual Calculation it adds this into a column, and for each month, so doubling the number of columns. How can I do this so it adds underneath? Like the sample below: to look like this: In excel it's a simple thing to do, Power BI has me stumped. It's likely a simple thing and I'm not seeing how. I can upload sample data and power bi files if needed (and someone can tell me how) many thanks in advance BarrySimple Matrix with Variance
HI there I am a very new user to Power Bi, and struggling with something I thought must be a simple visualization. For my data I need to show a matrix, years in the columns and months in the rows, with the spend per month/year shown. This I can do easily. My data is very basic. However, I also need to show the variance from last year to this year, and this is where I get stuck! Using co-pilot it supplied a dax formula, however that also shows the variance for last year (against nothing so shows as a minus) and it seems this can't be hidden/excluded. The end result i need is: 2024 2025 Variance Jan 24.50 39.21 14.71 Feb 13.95 24.56 10.61 Mar 32.10 29.55 -2.55 etc Is this doable? I am trying to show my company, and those that make the decisions, the Power Bi is a worthwhile expense, but struggling with this very basic starting point. The data can be run in any way needed. I'm quite proficient with Power Query so that side isn't an issue. many thanks
