Forum Discussion

eacy's avatar
eacy
Helper II
10 years ago

Slicer instead of hardcode

Hi,   Could anybody guide me how to use a slicer instead of having hardcoded value. I am having a custom column where I have hardcoded "assignee" and would like to have a slicer that would change t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi eacy,

 

   let me understand...you want a slicer made by a chart that runs on not duplicated values and that checks that the values of the [FIELD] column must be "assignee" and that values of the [groupid] column must be the same of the [ID] column of another table. Am I right?

 

Just like austinsense have said, if you give us some dataset samples or some screenshots we can help you better.

 

#I'M Not An Expert#

 

 

 

  • eacy's avatar
    eacy
    Helper II
    10 years ago

     

    Earlier Change (M) = 
IF('jiradb changegroup'[ID] > 0;
DATEDIFF(
	CALCULATE(MAX('jiradb changegroup'[CREATED]);
		FILTER(ALL('jiradb changegroup');
			'jiradb changegroup'[issueid] = EARLIER('jiradb changegroup'[issueid]) && 
			'jiradb changegroup'[CREATED] < EARLIER('jiradb changegroup'[CREATED]) &&
			NOT(ISBLANK('jiradb changegroup'[Slicer]))
	));'jiradb changegroup'[CREATED];MINUTE)
;BLANK())
    Slicer = CALCULATE(VALUES('jiradb changeitem'[FIELD]);
	FILTER('jiradb changeitem';'jiradb changeitem'[FIELD] = "assignee" && 'jiradb changegroup'[ID] = 'jiradb changeitem'[groupid]))

     

    Hi,

     

    I would like to be able to fetch the value of the slicer and replace the hardcoded "assignee".

    So, the slicer should slice the tabel but also give me input to the calculation I make in the "Earlier Change (M)" which calculate the time from the previous row with the same "FIELD" value.

    Right now it calculate the time from the previous row no matter which value it has.

     

    Thanks for your effort