Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I would like to show two 100% stacked bar chart with current result and latest last result, and when I filter the name then I can show the two charts automatically. Below is the sample data:
Name | Q1_A1 | Q1_A2 | Q1_A3 | Date |
A | 70% | 20% | 10% | 1/9/2022 |
A | 50% | 20% | 30% | 5/9/2022 |
A | 20% | 20% | 60% | 8/9/2022 |
A | 50% | 40% | 10% | 13/9/2022 |
B | 30% | 30% | 30% | 2/9/2022 |
B | 80% | 10% | 10% | 8/9/2022 |
A | 20% | 20% | 60% | 20/9/2022 |
A | 50% | 20% | 30% | 25/9/2022 |
B | 30% | 30% | 40% | 12/9/2022 |
B | 20% | 20% | 60% | 18/9/2022 |
The expected outcome should be when i filter A in the report view, it return two 100% stacked bar chart, one with
20% | 20% | 60% |
and one with
50% | 20% | 30% |
when i filter B in the report view, it return two 100% stacked bar chart, one with
30% | 30% | 40% |
and one with
30% | 30% | 40% |
Solved! Go to Solution.
Hi @Hayoung,
You can do unpivot column on your 'Quarter' fields to convert them to attribute and value. then use the date on your chart axis and attribute the legends, and value to the value fields.
Unpivot columns (Power Query) (microsoft.com)
After these steps, you need to write a measure filter to check corresponding date ranges and return tags then use it on the chart to filter matched records to cooperate with the Name filter to achieve your requirements.
Applying a measure filter in Power BI - SQLBI
Regards,
Xiaoxin Sheng
Hi @Hayoung,
You can do unpivot column on your 'Quarter' fields to convert them to attribute and value. then use the date on your chart axis and attribute the legends, and value to the value fields.
Unpivot columns (Power Query) (microsoft.com)
After these steps, you need to write a measure filter to check corresponding date ranges and return tags then use it on the chart to filter matched records to cooperate with the Name filter to achieve your requirements.
Applying a measure filter in Power BI - SQLBI
Regards,
Xiaoxin Sheng
Would it be a problem rendering two charts side by side instead?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
9 | |
3 | |
3 | |
2 |