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.
Hi All,
I'm having an issue with regards to the matrix functionality on power BI.
I have imported the following work book from excel.
When I generate the matrix in power BI, I'm getting blanks for projected sales for the first 2 years. I do not want to show those columns and only want to show the projected sale column for 2019 year only. Any idea how I can remove those views from matrix? If I try to use the exclude button and try to exclude project sales only, it removes the entire year and total sales cloumn as well.
Any advice or help would be appreciated.
Solved! Go to Solution.
Hi @fazad,
For your requirement, you could create a calculated column to achieve your desired output.
Column = VAR sum_of_project_sales = CALCULATE ( SUM ( 'Table1'[Projected Sales] ), ALLEXCEPT ( Table1, Table1[Year] ) ) RETURN IF ( ISBLANK ( sum_of_project_sales ), 0, 1 )
Then you could drag the calculated column to visual level filter and set like below.
More details, please refer to the attachement.
Best Regards,
Cherry
Hi,
You may refer to my solution in this PBI file. My numbers are different from yours because i created a summy dataset.
Hope this helps.
Hi @fazad,
For your requirement, you could create a calculated column to achieve your desired output.
Column = VAR sum_of_project_sales = CALCULATE ( SUM ( 'Table1'[Projected Sales] ), ALLEXCEPT ( Table1, Table1[Year] ) ) RETURN IF ( ISBLANK ( sum_of_project_sales ), 0, 1 )
Then you could drag the calculated column to visual level filter and set like below.
More details, please refer to the attachement.
Best Regards,
Cherry
Hi Cherry, Apologies for the late reply, your advice worked, thanks!
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 |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |