Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hey all,
Sample data: SampleData1.xlsx
I have a main table with columns for DateTime by the minute, an open price, a close price, a high price and a low price. I have added a week day and number column as well. I also have a DateTable with week day info (day, day number, week number, etc).
My requirements are to create an output / visual table that shows a table:
Example below:
My first thoughts were to create separate date tables to filter each the start and end of the week and create measures from those. However I run into an issue when applying the filters to the table visual, I get a blank result. It seems I am having trouble filtering individually the week start and week end and having them populate appropriately in the table visual.
Thanks everyone
Solved! Go to Solution.
You want to think long and hard before you go for this - it is very klutzy and I don't think the user experience will be meaningful
And yes - the week number column is critical. It will not work without it.
Thanks @lbendlin ... the output would still follow the parameters: I.e. open price 7/9 to close price 7/16, next row open price 7/16 to close 7/23, etc.
Assuming that is possible, otherwise we will not be able to do week day to same week day.
Thank you! I've given this a test run and I agree it's a bit wonky but it will accomplish what I am trying to solve. I really appreciate the guidance on this, it's helped a ton.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
83 | |
79 | |
53 | |
39 | |
37 |
User | Count |
---|---|
104 | |
85 | |
47 | |
44 | |
42 |