Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi there,
Refer to the below post,
http://community.powerbi.com/t5/Service/replace-measure-item-on-matrix/m-p/315453#M36255
I would like to know how to create drill down function and slicer for the "Union" table (by product). thanks
Best regards,
ER
Hi @erihsehc,
Normally power bi only support auto analysis date column to date hierarchy.
For your requirement, you can manual create custom hierarchy column and use it in hierarchy slicer.
Regards,
Xiaoxin Sheng
I created another data model as below,
If the below table can be updated by the product slicer selection, i think the problem is solved (currently no update of the 1st row when the slicer selection is changed), would expert help? thanks
using formula to create that table: new table = {(1,CALCULATE(SUM(Sheet1[amt]),FILTER(ALLSELECTED(Sheet1),Sheet1[item]="1.sales"))),(2,2),(3,3)}
Best regards
ER
Hi @erihsehc,
After check on your sampe, I haven't found any available relationships or mapping to new table.
For your scenario, I don't think it will be possible to filter new table based on product column.
Regards,
Xiaoxin Sheng
hi @v-shex-msft, actually, I would like to use "product" slicer to filter the "union" table, any idea on that
@v-huizhn-msft, would you help to modify the data model thanks
Best regards
ER
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.