topic Re: Guy in A Cube Video "How do you conditionally highlight a bar in a Power BI Report" in DAX Commands and Tips

Guy in A Cube Video "How do you conditionally highlight a bar in a Power BI Report"

Anonymous — Wed, 12 Oct 2022 17:21:05 GMT

I realize I am probably in the wrong support area, and I apologize in advance.

I watched this video last week and it is a very interesting concept and one I would like to implement.

Unfortunately I cannot locate the complete DAX code for the measure “BarToHighlight”.

Does anyone know where I can locate he complete DAX code?

I appreciate everyone’s help in locating this code.

Thanks

Re: Guy in A Cube Video "How do you conditionally highlight a bar in a Power BI Report"

tackytechtom — Wed, 12 Oct 2022 19:49:05 GMT

Hi Anonymous ,

I am not sure what you mean by "locate". Do you mean where Patrick saved the measure? It appears to be in the disconnected table:

Or are you after the whole DAX code for the measure?

By the way, I liked that video! Did not know how to do that either. Also the syncing of the slicers at the end is a nice little trick to know as well 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Re: Guy in A Cube Video "How do you conditionally highlight a bar in a Power BI Report"

Anonymous — Thu, 13 Oct 2022 12:30:29 GMT

Thanks for the quick reply and question clarifying what I am looking for.

I am looking for the entire code for the measure or the PBIX associated with this demo.

Yes, the concept of syncing slicers is very interesting and an idea I noted in my BI notebook.

Re: Guy in A Cube Video "How do you conditionally highlight a bar in a Power BI Report"

Anonymous — Mon, 17 Oct 2022 18:27:46 GMT

tackytechtom,

Not pushing, but have you had any luck in locaing the DAX code? Do you have another suggestion where I could ask for this code?

Thanks for your help.

Pierce

Re: Guy in A Cube Video "How do you conditionally highlight a bar in a Power BI Report"

tackytechtom — Mon, 17 Oct 2022 19:33:45 GMT

Hi Anonymous ,

How about this:

BarToHighlight =
VAR _selectedmonths = VALUES ( SELECTEDDATE[Month] )
VAR _monthtohighlight = SELECTEDVALUE ( 'CALENDAR'[Month] )
VAR _filtered = ISFILTERED ( SELECTEDDATE[Month] )
VAR _result = SWITCH ( TRUE, NOT ( _filtered ), "#0079EB", _monthtohighlight IN _selectedmonths && _filtered, "0079EB", "99C9F7" )
RETURN
_result

Was that the right code?

Let me know! 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/