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 have used DAX code to use UNICHAR for showing Loss in financial data, but I am getting the above error. Please help (Note- I am using financial data by Power BI desktop)
Solved! Go to Solution.
@azeemkhalipha , As I suggested above, I created it as a measure and that seems to be working. Please find the file attached after signature.
@azeemkhalipha , As I suggested above, I created it as a measure and that seems to be working. Please find the file attached after signature.
@azeemkhalipha ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@azeemkhalipha , Error is not clear.
But in case you are creating a color measure
if should if
if(sum(financials[profit]) <=0 , "Red", "Green")
Refer these blogs
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
The "Enterprise" row is showing twice when I add the DAX function. I want it to be in one row only with "red" remark
Download sample PBIX with this code and visual
As a Measure use this
Remark =
VAR _Red = UNICHAR(128308)
VAR _Green = UNICHAR(128994)
RETURN
IF(MAX('Financials'[Profit]) <= 0 , _Red, _Green)
Regards
Phil
Proud to be a Super User!
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |