FORMAT result according with filter and put It in a bar chart

[John_Silva642]

Hi,

I'm trying to create a code that FORMAT the result according to the selected filter.

My code works on cards, but It doesn't work on the bar charts.

Can someone help me, please?

Below there is the DAX code and a data model example.

PERFORMED_BY_TOTAL_TWELVEMONTHS =
VAR _LASTREF =
CALCULATE(
MAX('DBN'[Data]),
'DBN'[Tipo] = "PERFORMED/TOTAL",
'DBN'[Valor] <> BLANK()
)
VAR _ELEVENMONTHSAGO =
EDATE(_LASTREF,-11)
VAR _INDICATOR =
CALCULATE(
SELECTEDVALUE('DBN'[KPI], "ERROR"),
'DBN'[Tipo] = "PERFORMED/TOTAL"
)
VAR _RESULT =
CALCULATE(
SUM('DBN'[Valor]),
'DBN'[Tipo] = "PERFORMED/TOTAL",
'DBN'[Data] >= _ELEVENMONTHSAGO
&& 'DBN'[Data] <= _LASTREF
)
VAR _FORMAT =
IF(
_INDICATOR = "% Valor pendente",
FORMAT(_RESULT, "0.000%"),
IF(
_INDICATOR = "Quantidade Propostas Eletrônicas Total",
FORMAT(_RESULT, "Standard"),
FORMAT(_RESULT, "Percent")
)
)
RETURN
_FORMAT

Just _RESULT

[v-jianboli-msft · Accepted solution]

Hi @John_Silva642 ,

Have you ever considered about using field parameter?

Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your report readers explore and customize the analysis of the report by selecting the different measures or dimensions they're interested in.

For example:

Then apply to the visual:

For more details, please refer to:

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[John_Silva642]

It solved my problem. Thank you!

[v-jianboli-msft]

Hi @John_Silva642 ,

You can't use the Format function in your bar chart because it will convert the values to text format, making it unrecognizable to visual.

For more details, refer to:

FORMAT function (DAX) - DAX | Microsoft Learn

You can change the format of your measure here:

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[John_Silva642]

Thanks @v-jianboli-msft

But I need something like the FORMAT function to change the result according to the filter.

Example:

Percent FORMAT (Standard)

Percent FORMAT (0.000%)

Percent FORMAT (Percent)