This solution is only for dates column. For other columns you will have to create a new table and create relationships similar to what is shown in the video.
I am working on a dashboard that is required to change conditional formatting based on user input. For eg. There is a target and conditional formatting is done on it based on Minimum value to 90% down arrow 90% to 100% horizontal arrow Above 100% up arrow. Now the user wants that the conditional formatting of target should change based on his selection for eg. If the user wants to change the target % from Minimum to 80%, then arrow should change like Minimum to 80% down arrow, 80% to 100% horizontal arrow Above 100% up arrow. Please help..
This is a god send thank you so much
Hello, can this be done in any other way other than calender table? I need to do similar activity but based on another kind of slicer - not date
See this tutorial - hope this helps.
th-cam.com/video/jQOsHx96RiU/w-d-xo.html
Very useful, my friend!
Glad it was helpful!
will it work if Sales and Invoice tables are already connected ?
I'm having the same issue, where if both tables already have an active relationship it won't work.
Filters working perfect for date but if I select other column slicer then its not filtering values. Please advise.
This solution is only for dates column. For other columns you will have to create a new table and create relationships similar to what is shown in the video.
I am working on a dashboard that is required to change conditional formatting based on user input.
For eg.
There is a target and conditional formatting is done on it based on
Minimum value to 90% down arrow
90% to 100% horizontal arrow
Above 100% up arrow.
Now the user wants that the conditional formatting of target should change based on his selection for eg.
If the user wants to change the target % from
Minimum to 80%, then arrow should change like
Minimum to 80% down arrow,
80% to 100% horizontal arrow
Above 100% up arrow.
Please help..
This is possible.. shall post the tutorial on Monday Morning.
@MITutorials Thank you, will wait for your video..
Dynamic Conditional Formatting | Let users decide the % values to format | PowerBI | MiTutorials
th-cam.com/video/OXZO9sIQwCE/w-d-xo.html