Some small tricks to customize the background colour of a text box, a card, a chart, visual, etc. or to hide them based on the selection that I will do with a slicer. Let’s start first by personalizing the background, I have this text box with this slicer:
First I have to create a measure and there are 2 options, using IF or SWITCH. For both, I have to combine with SELECTEDVALUE, ISFILTERED, etc.
NOTE: change “table”, “argument”, “colorcode1” and “colorcode2” by yours. Now I will have to link them all together:
So if there is no selection, the background will be blank (#FFFFFF), if “yes” is selected, it will change to orange (#E66C37) and if it is “no”, blue (#118DFF).
NOTE: if I want the background to be transparent, just add 00 at the end of the code colour, for instance: #FFFFFF00.
To make disappear visuals (table, pie, slicer, etc.), there are 2 options, one taking a screenshot focused for offline data and the other one, more focused for live data. Anyway, based on what you need, use whatever you want. I have those 2 charts, one is called “hide” and the other “seek”:
The first option is better for data not updated many times because it will take a snapshot of the current situation (take note that slicers/filters can’t be used, buttons or shapes should be created/configured to act like slicers/filters):
hide | seek | clear |
If I “CTRL + click” on the:
NOTE: once published, the “CTRL + click” will be changed on “click” only.
If I want to combine both charts so making my audience believe that there is only 1 chart instead of 2. I will put one above the other (if need be use “bring forward” or “send backward” options under “format”)
And I will not create “bookmark 3”:
The second option is better for data in real time using a direct connection to be updated every second. I will take the same charts and I will use the same slicer (the one I use to personalize the background). The goal is to combine them together so to make the audience thinks that there is only 1 chart. 2 measures have to be created:
NOTE:
Let’s do magic:
HIDE | SEEK | |
If I select nothing, “seek” can be seen. Same thing if “no” is selected but if I select “yes”, “hide” appears and “seek” disappears.
When “hide” appears (right picture), its title is mixed with the “seek” one, to make it disappear, go to “title” and do the same thing as for the background. If not, put the same title for both or just be creative !!!
What happens if my filter is a logical type ? For instance:
The rules are not the same, to make it work, first, I will have to create a new table duplicating it because using the original one, it will not work:
Replace the filter by this new one and don´t forget to create a relationship:
Once done, I will create my 2 formula:
I have those 2 tables that I will combine into 1, my goal is to make appear the color one only if I will select "false":
So:
The result is if I don´t select nothing, grey one will show, same thing if I select "true" but selecting "false", the color one popups:
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...