topic Re: Measures display in a certain format in DAX Commands and Tips

Measures display in a certain format

ashrat001 — Tue, 04 Oct 2022 07:20:12 GMT

Hi Experts,

I have a few measures having data of Actual Volume, Budget Volume and SPLY Volume and same for NSI and other KPIs.

I want to display in the below format.

Your valueable inputs will be apprecaited. Thanks!

TA

Re: Measures display in a certain format

Greg_Deckler — Tue, 04 Oct 2022 07:45:46 GMT

ashrat001 Try a Custom Format String? Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

Re: Measures display in a certain format

ashrat001 — Tue, 04 Oct 2022 08:25:30 GMT

Hi Greg,

Thanks for your prompt response. But how would this help me to get the desired result? I'm unable to use it. Thanks!

TA

Re: Measures display in a certain format

Greg_Deckler — Tue, 04 Oct 2022 08:34:35 GMT

ashrat001 IDK, I assumed that you wanted like EBIT to display with negatives being in parens. Is that not what you were talking about? If not, what exactly are you talking about? That you want a red main column header? That you want certain rows to be certain colors, that you want certain rows to be italicized, that you want the fonts to be Comic Sans? Please be specific as to your ask.

Re: Measures display in a certain format

ashrat001 — Tue, 04 Oct 2022 08:48:10 GMT

Hi Greg,

I have measures as below:

Volume	Actual Volume	Budget Volume	SPLY Volume
NSI	Actual NSI	Budget NSI	SPLY NSI
CM	Actual CM	Budget CM	SPLY CM
Opex	Actual Opex	Budget Opex	SPLY Opex

I want to show these measures in below format in a matrix/table visualization.

Thanks.
TA