Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I am trying to create a table that has the current quarter sales, the number of customers, and then the prior 4 quarters. I want the titles for the prior quarters to display the quarter that the info is for. Here is a screenshot that might help explain.
I have 2 tables, a date table and a table with dates, sales, and names. I have a measure for each prior quarter for example
@BaldAccountant , That is what it should give as long as Slicer / visual is using quarter from Date table?
What is missing ?
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Yes I am suing a slicer by quarter
I will try to send a link to the file, but my dropbox links have not worked for peope in the past
https://www.dropbox.com/s/3rc2h47omfz0eje/Test%20Quarters.pbix?dl=0
I am not 100% sure what you mean by it should work. I can make a table to show just the values by quarter, but I want to include other columns like I did with the count of names.
I created measures to get the prior quarter values and that worked, but the titles give the name of the measure. I want the date of the prior quarters.
PS thank for spending your time answering peoples questions. I have used a lot of your solutions for other people.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
89 | |
79 | |
59 | |
47 | |
40 |