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,
I have two visuals on a dashboard.
Visual 1 (Cakechart):
- This is showing the value of todays inventory split up in business area.
- It is filtered on Latest date from the date table
Visual 2 (Linechart):
- This one is showing the daily change using this formula
-----
DailyChange =
VAR Current =
CALCULATE(
Inventory[Value],
FILTER(
DimDate, DimDate[Date] = MAX(DimDate[Date])
)
)
VAR Prev =
MAXX(
FILTER(
ALL(
DimDate[Date]
),
DimDate[Date] < MAX(DimDate[Date])
),
DimDate[Date]
)
VAR PrevInventory =
CALCULATE(
Inventory[Value],
FILTER(
ALL(
DimDate
),
DimDate[Date] = PrevDate
)
)
RETURN Current - Prev
------
The problem:
When I select one business area on the cakechart my line chart gets filtered on both date and business area, but I only want it to filter on the business area so that the line chart remains.
I have tried different combinations of ALLEXCEPT and REMOVEFILTER, but I cant seem to get the right outcome.
Regards,
Anders
Solved! Go to Solution.
Hi @Anonymous
Create a measure to calcualte the value on the latest date and put it into the pie chart to replace the original column field. And remove the date filter on the pie chart.
Latest Value = CALCULATE(SUM('FACT'[Value]),FILTER(DIM_Date,DIM_Date[Date]=MAX(DIM_Date[Date])))
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Anonymous
Create a measure to calcualte the value on the latest date and put it into the pie chart to replace the original column field. And remove the date filter on the pie chart.
Latest Value = CALCULATE(SUM('FACT'[Value]),FILTER(DIM_Date,DIM_Date[Date]=MAX(DIM_Date[Date])))
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
You may want to change the way of interaction between visuals
Also, make sure that you have valid data for your business Area that is selected.
Power BI - Edit Interactions features - Power BI Docs
Change how visuals interact in a report - Power BI | Microsoft Docs
Proud to be a Super User!
This solution turns off all interaction. I dont want that, I still want it to filter on business area.
Can you please share some sample data after removing sensitive information?
Proud to be a Super User!
Hi,
I uploaded some sample data here.
Basically, I would like the line chart to still show daily development even when selecting a store on the cake chart.
Thanks.
A
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.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
56 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |