Solved: combining slicer-measure selection function in tab...

Anonymous · ‎12-19-2020

hi,

may i kindly ask if it's possible to combine the functions of slicer-measure selection (https://youtu.be/c0mPvzkf6i0) in tabular editor (https://youtu.be/vlnx7QUVYME) ?

tks: - nik

p.s.

for info, when i tried it, i get following error msg

PaulDBrown · ‎12-19-2020

@Anonymous

It looks like you have values in the column which are not numerical. You can identify them by selecting the column in Power Query and changing the sort order. You will then need to replace them with whatever value which can be identified as a number (or as "null"/blank if pertinent)

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

View solution in original post

PaulDBrown · ‎12-19-2020

@Anonymous

It looks like you have values in the column which are not numerical. You can identify them by selecting the column in Power Query and changing the sort order. You will then need to replace them with whatever value which can be identified as a number (or as "null"/blank if pertinent)

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.