any way to change Type depending on condition

[Anonymous]

Hi, 

Attached is a simple test spreadsheet. One of columns is called "Type" which consists of Wastage, Quarantine and Rework. 

  

On some occasions, although type is selected as Wastage, it occurs hours to spend for rework.

Since I need to populate data under different TYPE's but at the same time I need to capture rework hours, I put both information in a single line. 

With this raw data, I have separated Total amount into Wastage, Quaratnine and Rework as below.

Total Sum of Quarantine = calculate(sum(Testing[sum]), Testing[Type] = "Quarantine") 

Total Sum of Rework = calculate(sum(Testing[Rework Cost]) )

Total Sum of Wastage = calculate(sum(Testing[sum]), Testing[Type] = "Wastage")

With above, I plotted graphs as below

When I clicked a pie graph, bar graphs are not responded. 

 

Is there anyway to re-establish Type with condition where Rework cost" is Not zero, its cost belongs to Rework type. 

[Anonymous]

@amitchandak is there any way to do so? Or should i do something in power query, making a new row under condition where rework house is not blank, create a new row with Type set to Rework?

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Have you tried to apply ’Testing[Date].[Month]‘ to the ’Details‘ field of pie chart?

You can also try the following steps to modify your original model in power query.

1.duplicate a table ’testing2‘ ->remove column'Type',column 'Sum'

2. Unpivot the "Rework Cost" column,then rename the new column "Attribute" to "Type" and the new column "Value" to "Sum"

3. Duplicate a new table 'testing3' ->remove column 'Rework Cost'

4. Apend table ’testing3‘ with table 'testing2' to create a new table 'Append1'

5.In the new model, apply the field 'Type' to the 'legend, you don't need to create additional measures.

Best Regards,
Community Support Team _ Eason\

[Anonymous]

Thank you @v-easonf-msft 

[amitchandak]

@Anonymous , Because the pie is using only measures. Only dimension values(common - Non summarized), can filter the visuals (interact)