Forum Discussion
PLEASE HELP, CHALLENGING VISUAL
- Anonymous6 years ago
First, I am going to assume that you are already calculating "Estado Estación". You are only asking if, given a value in "Estado Estación," how can you best visualize this in Power BI as red or green. Correct?
If yes, then add a column that changes "Estado Sistema" to a numeral (example below).
With that change to your data, the easiest solution is a Table visualization. In a Table visualization, you can set the background color or use an icon for a specific value.
1. In the Values list for the Table, click the down arrow for the "Estado Sistema" field.
2. In the pop-up menu, choose Conditional formatting > Background (The other options are similar. I will show Background below.). The same setting can be found in the Table format (paint roller).
3. Make the Background settings as shown below.
4. After pressing OK, you will get a result like this.
You can change the look of this by putting the Country (Pais) into a horizontal Slicer and the City (Ciudad) into a Table with Icons. The same Conditional Formatting as used above will get you the icons.
Choosing "Colombia" ...
Hi,
Did the first reply solved your issue?
If so, please mark it as a solution for others to see.
Best Regards,
Giotto