Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Is there a way to filter using slicers in Power BI that will give all the numbers for the Quarter upto that point? For example I have the following quarters as columns in a matrix visualization 2021-Q1, 2021-Q2, 2021-Q3, 2021-Q4, 2022-Q1, 2022-Q2, 2022-Q3 etc
(Included is a screenshot of what I'm looking to acomplish.)
Currently if I were to use a FY-FQ slicer for a particular quarter it will only show the sum for the quarter.
What I want is to be able to pick a FY&FQ quarter on the slicer and it show me previous quarters too on the column headers and not anything in the future.
For example, if I were to pick 2021-Q4, the Maxtrix visualization would show columns 2021-Q1, 2021-Q2, 2021-Q3 and 2021-Q4 with their totals, but not anything after, but everything before 2021-Q4.
Solved! Go to Solution.
Hi @Jamming_Mon ,
By my test, we can only get it in a table visual like below.
1.Create a new table, don't make relationship with the fact table.
Quarter = values('Table'[Quarter])
2.Create a measure.
Measure =
IF ( MAX ( 'Table'[Quarter] ) <= SELECTEDVALUE ( 'Quarter'[Quarter] ), 1, 0 )
Then put the Quarter column of the new created table in slicer, and put the mesure in the table visual filter, select it's value to 1.
Get the correct result.
Matrix visual cannot be filtered like this. I attach my sample below for your reference.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Jamming_Mon ,
By my test, we can only get it in a table visual like below.
1.Create a new table, don't make relationship with the fact table.
Quarter = values('Table'[Quarter])
2.Create a measure.
Measure =
IF ( MAX ( 'Table'[Quarter] ) <= SELECTEDVALUE ( 'Quarter'[Quarter] ), 1, 0 )
Then put the Quarter column of the new created table in slicer, and put the mesure in the table visual filter, select it's value to 1.
Get the correct result.
Matrix visual cannot be filtered like this. I attach my sample below for your reference.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |