Forum Discussion
Avivek
5 years agoPost Partisan
Alternative for drilldown function
I have a table which has ad, vp and sales rep name along with some other data which are in the form of text. And hence I cannot use a matrix to see this visual. Now I want to see the AD's, VP'...
VijayP
5 years agoCommunity Champion
In Power Query Editor you can Get a Column using Column from Example with only the name of VP/or other required names
then you can easily use the same in the matrix without any additonal hassel
Vijay Perepa
VijayP
5 years agoCommunity Champion
https://drive.google.com/file/d/1-Dr3RYMZj3vsPaeKTTSlnB8sTlMY83o0/view?usp=sharing
Watch this Video for Clarity
If you find this as solution please mark it as solution and share your Kudoes
Vijay Perepa