Calculate dynamic field in a table
Hello, I have data fed from an excel sheet of an investment portfolio, this table contains columns like (Investment, type, purpose, value..etc) In the type column, I have 3 categories (Properties, Stocks, and cash). What we want to achieve is to pull daily stock prices from the internet (which I managed to do that), then I have to calculate the networth by sum the values of properties, cash as well as the stock value (based on the current stock price) I am still a begginer, and I have managed to pull the stock prices, however I am stuck in creating a table that have those nearly static values (properties and cash) as well as a field for those dynamic wealth (stocks) and display that using pie charts and stuff. what should I do, please help
Switch colour card filter by field value
I'm formating a card by FIELD VALUE Is there a way to get this switch formula to turn greater than 0 green e.g. "#094" and red if less than 0 e.g. "#d64550"; My current code is: Measure Value Color = SWITCH(TRUE(), [% Average 2019] >0,"#D64550", [%Average 2019] =0,"#252423", [% Average 2019] <0,"#094", [% Average 2020] >0,"#D64550", [% Average 2020] =0,"#252423", [% Average 2020] <0,"#094" ) It keeps turning red for some reason when it's +18.54% ThanksConditional Formatting on a Switch Metric - Tabular Model
Hello, I am attempting to use the Conditional Formatting - Field Value functionality on a switch metric for a Card visualization; however, the field selector does not let me choose a field value from my model. The "OK" button is grayed out for every metric from my model. The switch metrics are all functioning properly if I view the data in a normal table format with the coloring metric accurately displaying the Color metric as "Red", "Green", "Yellow", etc... as a text field in the table. The data model was published through visual studio to a serve and the PowerBI file is connected to the server hosting the data model. Are there any conditional formatting - field value limitations when connecting to a tabular data model? The field value functionality seems to work through switch metrics for me when housing the data within the PowerBI file. Thank you!
