Forum Discussion
Hide rows if a column is empty
Hi Yulia, thanks for your reply.
I found the solution by adding a filter using Actuals Posting Period. Now only the periods displayed in the Actuals table will be shown in the PowerBI table which is what I wanted. ( Before i could see 12 periods even though I had only two months worth of data for Actuals). The only downside with this method is that the slicer is visible in the report view.
Thanks again
Piero
Before I could see 12 periods in the BI table cause the Budget file has 12 periods but by using the filter I can match it to the actuals periods so tba
Community SupportHi pi8080 ,
I am not sure if I understood your question correctly.
Based on the information you provided, I assume you have two tables: Actuals and Budget.
Here is the dummy data I created.
Table-Actuals
Table-Budget
Please try code as below.
Variance =
IF (
SELECTEDVALUE ( Actuals[Actual] ) = BLANK (),
BLANK (),
SUM ( Actuals[actual] ) - SUM ( Budget[budget] )
)
Result is as below.
Is this the result you expect?
If I've misunderstood you, can you share sample data and the results you are hoping for? Show it as a screenshot or excel. Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yulia, thanks for your reply.
I found the solution by adding a filter using Actuals Posting Period. Now only the periods displayed in the Actuals table will be shown in the PowerBI table which is what I wanted. ( Before i could see 12 periods even though I had only two months worth of data for Actuals). The only downside with this method is that the slicer is visible in the report view.
Thanks again
Piero
Before I could see 12 periods in the BI table cause the Budget file has 12 periods but by using the filter I can match it to the actuals periods so tba