User Profile
redalert787
Helper II
Joined 5 years ago
User Widgets
Contributions
Filtering differently on several metrics in the same matrix table
Hello, I would like to see if there is a simple way to filter metrics individually on Power BI desktop. For example, I have a matrix table that shows the Month to date (MTD) invoiced sales and our forecast and the performance versus last year. In the same table, I also have the same metrics but for a different timing of year to date (YTD). I do this for several different metrics and thus I'm currently creating formulas to filter on the month or year for each one. I imagine that there is a simpler way, can anyone help me with this? Please see below a screen shot of the table: Thanks for your helpRe: Updating a text box with database update date
Hello, I created a table in excel with a column for showing when each of my databases were updated. I created a DAX measure based on the one that noted above. Then I put the measure into a card but it is showing blank. Would you be able to help to show me where I am going wrong JoeBarry Excel table: DAX measure: Card showing blank for measure: Thanks,Re: How to create a YTD button & Period filter
Thanks ribisht Unfortunately, the videos on time intelligence don't answer exactly what I am lookingfor since the date table that I update is manual and therefore sometimes the MTD will not exactly be based on todays date. My request for the moment was actually much more simple: how can I have the same tab "MTD", "QTD", "YTD", but filtering on the month table that I have copied above.How to create a YTD button & Period filter
Hello, I have a finance report and with a filter for the months of the year. I would like to add a horizontal filter where the user can choose YTD (the finished months of the year) and a button for "period" which is the ongoing open month. The table for the months looks like the below (i use the field "month so short") Could you help me identify the easiest way to create a button for 'YTD' & 'period'. For example, at the moment YTD would filter from Jan to Aug, and period would filter for Sep. merciRe: Deleting columns from appended manual Excel tables
Hi Joe, Sorry I don't think I was very clear. I meant I want to delete a column from all of the tables and make sure that the refresh functioned in excel. I don't want to delete an entire table. Normally in the advanced editor, there is the "changed type" step that includs all the columns but in the appended table this does not exist. Therefore, if I remove the columns from the excel source data I think the refresh would give me an error.
