Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I am creating a PowerBI dashboard to calculate the cost of buying tables from different suppliers. There are a total of 3 suppliers which provide either tabletop and legs separately or tabletop and legs together.
This data has been consolidated in one dataset with the following structure: Supplier, tabletop.material, tabletop.dimensions, leg.height, unit.cost.
For example when the leg is sold separately the tabletop.material and tabletop.weight will be NA.
The user then inputs their wished table specification in slicers and powerbi shows the result in table visuals. I was able to create 3 table visuals which each have the cost for leg only, table only or leg + table.
The issue that I face is that these tables combine different suppliers. For the purpose of the user, I would like to have one table visual per supplier. For example, for supplier Akielo, we would have one row for legs only + cost, one row for tabletop only + cost and total cost for this supplier.
I have also supplied the PowerBI file. https://we.tl/t-tStp4iFkhV
@Anonymous , I only get part of it. If you want to change the complete column set based on selected value in the slicer, you need bookmarks
Axis Slicer
Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
Hi @amitchandak , thank you for your response, just to be more clear, I would like to transform the table visuals so that there are only 1 supplier per table (as shown in the image).
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
206 | |
90 | |
61 | |
59 | |
57 |