Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 @v-yiruan-msft ,
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 @v-yiruan-msft ,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |