how can use measures for comperision in conditional formatting using power bi
I made two measures to find the sales amount for this day and the previous day. Now, I want to make a comparison between the amounts. I want to use an up arrow icon and a down arrow icon to show me which value is higher than the other. I mean like this I tried to use conditional formatting, but it is difficult to add a measure for comparison." what sould i do ?
Add Search capability to a numeric type field with out transforming data
Problem: I need to add a search capability to a userID field, which is of numeric type. However, it seems that search functionality is only possible on text type fields. Constraint: There are restrictions on making changes to the model or transform data step, and there's a live connection set to the data. Attempts So Far: I can't change the data type in the model view or use advanced query because that requires a transform data step. I can't create a calculated column using DAX, as I couldn't find any option to create a new column in the report. I tried creating a measure to extract the userID from other columns, but creating a measure on a non-calculated column is not supported. Does anyone have any suggestions on how to tackle this issue or if any of my observations above are incorrect? Any help would be greatly appreciated. Thanks!
Web URL conditional formatting not showing any fields
I am working on a table that needs to have a Web URL on a cell element. This report is in Power BI on the web not on the desktop app. When I create it with the same data source on the desktop app the Web URL works just fine the issue only presents itself in the web Power BI. This is a screenshot of what I get in the web Power BI This is a screenshot of what I get in the Power BI desktop For our situation we need the report to be in the web Power BI and I don't want to spent two days rebuilding the report in the desktop app if there is a setting or some other field that I might be over looking that can fix this issue.
