Forum Discussion

S184019's avatar
S184019
Advocate III
8 years ago

Calculated field data bars

Is it possible or perhpas already in the works to be able to add data bars to DAX calculated fields?  Once a field is calculated it seems that the data bar option is no longer available.    Thanks,...
Dashboards
S184019's avatar
S184019
Advocate III
8 years ago

Hello, 

 

       I have a table with multiple calculated fields.  One is a integer, another a decimal and so on.  Within that table I needed to add a percent of those fields.  Not a problem, got that added and formatted with the necessary conditionality, but once I did, I lost the conditional data bars.  

 

       How does one go about adding those data bars back using DAX?  Below is a snippit of my DAX code.

 

Summarized Table = 
UNION(
(ADDCOLUMNS (
    SUMMARIZE (
        'Measure',
        'Measure'[Dept],
	    "Value", SUM('Measure'[Target1]),
        "Target", BLANK()
    ),
    "Type", "Your FYTD Target", "Sort", 2 )),
(ADDCOLUMNS (
    SUMMARIZE (
        'NTC Summary',
        'NTC Summary'[Dept],
    "Value", SUM('NTC Summary'[Value]),
    "Target", SUM('NTC Summary'[Target])
    ),
    "Type", "Your Value", "Sort", 3 )),

(ADDCOLUMNS (
    SUMMARIZE (
        'Measure',
        'Measure'[Dept],
    "Value", SUM('Measure'[Target2]),
    "Target", BLANK()
    ),
    "Type", "Your Target", "Sort", 1 )),
(ADDCOLUMNS (
    SUMMARIZE (
        'Measure',
        'Measure'[Dept],
    "Value", FORMAT('Measure'[% Growth]/100, "Percent"),
    "Target", BLANK()
    ),
    "Type", "Avg % Growth (FYTD v. PFYTD)", "Sort", 4 )))

Thanks in advance!

 

Humbly yours, 

 

Mark