Apply Conditional Formatting to a Column and am seeking assistance
Hello All, I would like to apply conditional formatting to a column and am seeking assistance. My goal is to enable users to select a color that will automatically be applied to a column header in Power BI, based on data sourced from Excel. For instance, if a user selects '1', the color should be green; for '2', blue; and for '3', red. Please be aware that the report is updated monthly. Therefore, as users change values in Excel each month, these changes should be dynamically reflected in Power BI. I'm facing a challenge with applying conditional formatting to a column instead of a row. If you have a more effective way to model the data, your suggestions would be greatly appreciated. My brain is a bit fatigued, just want to see column conditional formatted.😁 Can anyone provide a solution for this? I have included a screenshot below for better clarity.
Help formatting all websites the same
I have a column with a bunch of website links that are all formatted differently so extract and split column aren't working as it just removes all other websites that don't follow that format. I have websites starting with: https://www. or http:// or www. and some with no beginning to the link. Then some of the web links end with a / after the .com I'm wanting all websites to be formatted as domains so it would just be: websitename.com I'm not sure how to do this with a conditional column, custom column, calculated column or what. If I use split or extract it just messes everything up and makes things even more different. Any ideas? Please see reference picture to see what I'm working with.
Conditional formatting 2 columns to return colour
I have few tables as my data source. I created a table to show various columns from different data sources using table visual. I want to compare two columns based on certain conditions and in return highlight the cells. Here is my sample data : Table 1 : Material Material Name Sales Order MA01 Alpha 5123 MA02 Bravo 5124 1245 Charlie 5125 MA03 Delta 5126 Table 2: Material Storage location Stock MA01 DE 5 MA02 DE 10 MA03 US 6 1245 NL 12 Table 3 : Material Delivery quantity MA01 2 MA02 3 MA03 1 1245 10 Here is the visual I created based on above data : New_stock column is created on a column with rule to return values only if the storage location is - DE, NL otherwise return blank. Material Name Sales order New_Stock Delivery quantity MA01 Alpha 5123 5 2 MA02 Bravo 5124 10 3 MA03 Delta 5126 1 1245 Charlie 5125 12 10 I want to highlight the rows with below condtion If Delivery < 90% of stock return "Yellow" and if Delivery >= 90% of stock then no change in the colour. Could anyone please support and help? I have tried IFERROR and LOOKUPVALUE to get the columns in one specific table and then do the conditional colour formatting but does not seem to work. Any help would be appreciated. Thanks.
Column specific color scaling in Matrix table
Hi Experts! I am trying to colour scale based on values. When I apply conditional formatting, it is applying on the whole of the values in the Matrix table. Looking for a solution which applies colour scaling based on column specific values. Sample data can be seen in image below for understanding. Thank you for your support in advance! Result of work done(not an expected result): Desired result:
HOW TO SUM A VARIABLE THAT COMES FROM A MEASURE
Hello guys! I have to resume values from 3 different lines of production, which are "Lee Pack", "Rad Pack" and "Manual". To calculate the variable "Velocidad teorica" I use this conditional: Velocidad teorica = IF(OR([promedio]=1, [promedio]=2), (SUM(Estandares[Rendimiento maquina])/450), IF([promedio]=3,(SUM(Estandares[Rendimiento manual])/450), "0")) where 1 means "Lee Pack", 2 means "Rad Pack" and 3 means "Manual" Due to it is a conditional, in the table's total the value shown is the condition if false from the second conditional. Other variable is "Tiempo Teórico" where tiempo teorico = sum(Hora[No. Unidades])/[Velocidad teorica] so if "Velocidad teórica" is 0, then it would show infinite. Lastly, the variable "% CUMPLIMIENTO" is calculated: % CUMPLIMIENTO = if(([tiempo teorico]/[tiempo real])>100, "0", ([tiempo teorico]/[tiempo real])) My problem is that I can´t visualize the sum of "tiempo teórico", and i Think its because the conditional, same as "velocidad teórica" and "% cumplimiento". Do you know a way to do it? The data table is available in the link https://docs.google.com/spreadsheets/d/1QcCAdk9oMWi__oWiYaWkTop5OXn5feCg/edit?usp=sharing&ouid=103939786031930093563&rtpof=true&sd=true https://drive.google.com/drive/folders/1BpRDGXwfnV7QKtacQkmnR9kM7pIuxH06?usp=sharing
