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.
Hello,
In my SSAS tabular model I have the following measures, (which then used in Power BI Report):
% of Budget Used:=1.0 - DIVIDE(([Total Budget] - [Total Amount]), [Total Budget], BLANK())
% of Budget Used - consists from the followings:
Total Budget:=CALCULATE( SUM( 'GL Transactions'[Budget Amount] ), 'Calendar FY'[Date] )
Total Amount:= SUM( 'GL Transactions'[Amount])
After exporting these in Power BI Model, my report has the following result:
Are there ways to filter out the negative(s) values (marked in red)? My goal is to have blank, when it's negative...
I thought of using IsInScope function, but it isn't available in my current SSAS tabuler
May be I need to use IsFiltered instead? How exactly?
Thanks for help!
Hi,
you could use conditional formatting on color of that field and set that if the value is negative then color is white!
Chiara
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 |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |