Product name for a legend and table
I am working on a report for product association and a basket analysis - most commonly, products are purchased with each other. The idea is for the client to pick a product in the slicer and see a view of a table and a graph (so far). I will start with the table so you can visualize what I have: Picked Product ID Picked Product Name Associated Product ID Associated Product Name Associated Product Total Sales Associated Product Quantity 1 Coke 2 ? 40,00 5 1 Coke 3 ? 30,00 6 1 Coke 4 ? 30,00 8 So the issue is: I need to add the product name to the table. But of course, I already used that column, which returns the product name associated with the product picked in the slicer, which is currently being analyzed. I have a similar issue with the bar graph showing the total sales of the products by each associated item the legend shows the product ID and not the name. How can I have the name of the associated product displayed as well? Has anyone managed to solve something like this before? Thank you for your time!!
How to create a dynamic legend for matrix based on quarter selected
Hi I have a matrix visual that has % of Approved Request by Divison by Quarter. How can i make the quarter Dynamic? where it will show the current and previous 3 quarters based on the quarter that I have selected. I already have the measures for Current Quarter, and 3 quarters prior, but i am unable to make it dynamic.
Creating Customized Legend and Tooltip for Clustered Column Chart
Hi everyone! I hope you can help me with a visualization challenge I'm facing. I have created a clustered column chart to display year-on-year (YoY) inflation based on different cities. The chart shows two columns for each city: one for the current quarter and year's YoY inflation and the other for the YoY inflation from the previous quarter. I have also filtered the data based on selected quarters and years. Now, my question is: How can I customize the legend and the tooltip to dynamically adjust based on the selected filter values? For instance, if I select "Quarter I" and "2019" from the filters, I want the legend to show "QI 2019" for the current quarter and "QIV 2018" for the previous quarter. Similarly, I want the tooltip to display the respective inflation values for the selected quarters. Is there a way to achieve this in Power BI? I would greatly appreciate any insights or solutions you can provide. Here I attached an illustration of my current chart for reference. Thank you in advance for your help! ❤️
In Power bi Gantt 2.2.3 , percent completion value becomes 100% after adding legends
Hi , i am using gantt 2.2.3 visualisation to show progress of projects. I want to show legend colour based on project status , but when i am adding the field in legend the % completion is changing to 100% which is incorrect. 45 % is the correct progress. After adding the legend it is changing to 100%.
