Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a pie chart and my users wansts to see the top values in it first so it should look like a solid dot on the screen. Then when they use a slicer to filter the chart should look like a standard pie chart. Because this is a project that will be placed on PowerBI server filters will be applied using slicers the result should look like this.
product | export | domestic | date |
A | 0 | 3 | 5/15/2020 |
B | 15 | 0 | 5/15/2020 |
C | 20 | 0 | 5/15/2020 |
C | 0 | 27 | 5/16/2020 |
B | 30 | 0 | 5/16/2020 |
A | 0 | 21 | 5/16/2020 |
A | 0 | 12 | 5/17/2020 |
B | 10 | 0 | 5/17/2020 |
C | 0 | 15 | 5/17/2020 |
Hi @Roy_B
If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!
If not, please kindly elaborate more.
I tried to apply the mesures to my piechart but i could not get it to work. Here is a more detailed look at my data. Hopefuly this will help answer my problem
Color | Product | Customer | week of | Method | Sales Person | Domestic/Export | Day Soled | Ledgend | Green Products Sold |
Red | A | cust_A | 10/3/2020 | Method_A | Ray | Domestic | 7 - Saturday | Method_A - A | 19 |
Red | B | cust_B | 10/3/2020 | Method_A | Jo | Domestic | 7 - Saturday | Method_A - B | 14 |
Green | C | cust_A | 10/3/2020 | Method_A | Jo | Domestic | 3 - Tuesday | Method_A - C | 45 |
Red | B | cust_B | 10/3/2020 | Method_A | Ray | Export | 6 - Friday | Method_A - B | 56 |
Red | D | cust_A | 10/3/2020 | Method_A | Loui | Domestic | 3 - Tuesday | Method_A - D | 2 |
Green | C | cust_C | 10/3/2020 | Method_A | Gill | Domestic | 3 - Tuesday | Method_A - C | 14 |
Red | E | cust_A | 10/3/2020 | Method_A | Shaw | Export | 3 - Tuesday | Method_A - E | 67 |
Green | F | cust_A | 10/3/2020 | Method_B | Jo | Domestic | 7 - Saturday | Method_B - F | 0 |
Green | C | cust_A | 10/3/2020 | Method_A | Gill | Domestic | 7 - Saturday | Method_A - C | 48 |
@Roy_B , You have to use is filtered
example
Create two measure like these
sum domestic = calculate(sum(table[domestic]))
Top 1 = CALCULATE([sum domestic],TOPN(1,all(Table[product]),[sum domestic],DESC),VALUES(Table[product]))
and use with isfiltered
if(isfiltered(Table[product]) , [sum domestic] ,[Top1])
Also, refer
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
I found out what was my problem, it was my Legend. The formulas work but they only control the values and details but not the Legend, any ideas on how to filter it?
I have it working now, however it only responds with one ISFILTERED function. I tryed to these methods:
Created another measure for the ISFILTERED condition
TWSBC_isFiltered = IF( OR(ISFILTERED(Query1[VarietyColor]),
OR(ISFILTERED(Query1[VarietyName]),
OR(ISFILTERED(Query1[CustomerName]),
OR(ISFILTERED(Query1[Method]),
OR(ISFILTERED(Query1[SellingRegion]),
OR(ISFILTERED(Query1[WeekDay]),
ISFILTERED(Query1[SalesMan]))))))), TRUE(), FALSE())
did not use the measure and took the boolean expression in the if statement
IF (ISFILTERED(Query1[ProductColor]),
[sum domestic],
IF (ISFILTERED(Query1[Product]),
[sum domestic],
IF (ISFILTERED(Query1[CustomerName]),
[sum domestic],
IF (ISFILTERED(Query1[Method]),
[sum domestic],
IF (ISFILTERED(Query1[SellingRegion]),
[sum domestic],
IF (ISFILTERED(Query1[WeekDay]),
[sum domestic],
IF (ISFILTERED(Query1[SalesMan]),
[sum domestic],
[Top1]
)
)
)
)
)
)
)
In both cases my pie chart only displays the [sum domestic] values when nothing is filtered. It never displays the [Top1] value. I am positive that I am not filtering anything and that the boolean expresion works because I made that expression into a card for testing purposes.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |