Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am using a measure to filter and show the Actuals based on a user selection from Slicer.
For eg if the user selects December 2022 he only need to see data for oct 2022,nov 2022,dec2022,FY 2021, Q3 2022,Q2 2022.
I am using a combination of selectedvalue and filter for this measure and it does filters the date table.
Problem is i am getting blank columns for the filtered dates.
Is it possible for hide the blank columns where the filter is applied?
PFA images and measure i have written:
Measure =
Solved! Go to Solution.
hi @Anonymous ,
I fixed the issue using a change in relationship between date table and Actuals table.
Thanks for the reply
Hi @mikekim123 ,
Please update the formula of measure [ACTUALS IN MYEN Visibility] as below and check if it can return the expected result...
ACTUALS IN MYEN Visibility =
VAR SelectedMonth =
SELECTEDVALUE ( 'Date Helper'[FY Monthnum1] )
VAR Selectedyear =
SELECTEDVALUE ( 'Date Helper'[FY] )
VAR SelectedQuarter =
SELECTEDVALUE ( 'Date Helper'[FY Quarter] )
VAR Flag =
CALCULATE (
[ACTUALS IN MYEN],
FILTER (
'DATE FORMATTED',
(
VALUE ( 'DATE FORMATTED'[FY Quarter] ) <= VALUE ( SelectedQuarter )
&& 'DATE FORMATTED'[FY] = Selectedyear
&& 'DATE FORMATTED'[Time Cat] = "QQ"
)
|| ( 'DATE FORMATTED'[FY] = Selectedyear - 1
&& 'DATE FORMATTED'[Time Cat] = "FY" )
|| ( 'DATE FORMATTED'[FY] = Selectedyear - 2
&& 'DATE FORMATTED'[Time Cat] = "FY" )
)
)
RETURN
Flag
If the above one can't help you get the expected result, could you please provide some raw data in your tables (exclude sensitive data) with Text format, visual Field settings and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
hi @Anonymous ,
I fixed the issue using a change in relationship between date table and Actuals table.
Thanks for the reply
Hi @mikekim123 ,
It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. Thank you.
Best Regards
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
17 | |
8 | |
7 | |
7 | |
6 |
User | Count |
---|---|
23 | |
11 | |
10 | |
9 | |
8 |