The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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.
Solved! Go to 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\
@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?
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\
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |