Forum Discussion
Post PatronShow Value As
Hi
I created a visual (please see attached), but now I want to know if PBI like Excel Pivot Table has an option "Show Value as" for example Show As % of Grand Total, of Show As Running Total, etc.
Thank you very much.
You're welcome lastnn30 Has your post been solved now? Please click three dots and accept a solution so others can find it easily too.
Have a great one!
3 Replies
- AllisonKennedy
Community Champion
lastnn30 Yes, if you select the pivot table MATRIX as it's called in Power BI, in the visualizations pane you can click the down arrow next to your field and show as % of GT or whatever you'd like.
If you want an option that's not there, you can use DAX. Dax.guide is a great resource and you'll likely need the ALL or ALLSELECTED functions in combination with CALCULATE to get what you're looking for.
lastnn30Thank you so much for your help.
- AllisonKennedy
You're welcome lastnn30 Has your post been solved now? Please click three dots and accept a solution so others can find it easily too.
Have a great one!