I had such a specific need, never thought anyone would have such a learning-friendly video on this! Awesome stuff!
@danrolfe78627 ай бұрын
Thanks for this, cheers. Never underestimate the ability of an end user to completely avoid your intended method of delivery.
@bi-ome7 ай бұрын
🤣
@ankitsethi3166 Жыл бұрын
Awesome feature, thanks for sharing.
@bradj2298 ай бұрын
Cool idea about using a Matrix or Table via Bookmark. I wonder what the formatting looks like when you export a matrix into Excel..
@bi-ome8 ай бұрын
That's a good question, I just tried it and it looks pretty good! It doesn't make what I would consider a "proper" pivot table, but it does group the data visually like a matrix and puts the totals in bold font.
@SuperNunera5 ай бұрын
Just saved my life. Ty !
@roberttyler2861 Жыл бұрын
This is a nice feature - thanks for sharing. Is this part of a public available PBIX?
@bi-ome Жыл бұрын
Not currently, but I could clean it up and put it in github if it'd be useful. It's based on public data, so technically shareable. I've been putting all of my demos in a single file so I need to reorganize a bit. :)
@roberttyler2861 Жыл бұрын
@@bi-ome That would be really appreciated, keep going with these vids they are great!
@bi-ome Жыл бұрын
@@roberttyler2861 aw thank you! I uploaded the PBIX here, it's the Tutorials PBIX file. github.com/chpayton/BI-Files
@birdgreen2256 Жыл бұрын
Excellent
@jjg-ek1uz7 ай бұрын
Hi thanks for the video. Someone pointed me to that video because I needed to do a dynamic group by, but when we select fields in your "By..." field Parameter, we can still see several lines with the same fields, so it doesn't group them by these fields values. How is it possible to accomplish a real dynamic group by please ?
@bi-ome7 ай бұрын
That's true for the table, but if you use the "by..." dimension as rows in the matrix visual, it will group them up on whatever the unique values are.
@ShaunSlocumb5 ай бұрын
Works great in desktop but not when deployed to Report Server
@bi-ome5 ай бұрын
I am not sure if this feature is enabled for Report Server. The community threads for it indicate it was still in preview, but I don’t see a release date or mention of whether it’s GA now there or not. I am not using Report Server so it’s hard to check :)
@yathishkumar9770 Жыл бұрын
Hey, hi Christine. I have tried like you said and it a great one and while adding measures as field parameters and adding them dynamically to the table visual iam unable to use the conditional formatting for each measure with different conditions. Please lead me to solve this issue. Thankyou.
@bi-ome Жыл бұрын
Yeah, this video from Guy in a Cube might be what you want - you can add conditional formatting for field parameter measures in Cell Elements too: kzfaq.info/get/bejne/gbWVh5x12NGRqKM.html