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.
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
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])
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]),
ISFILTERED(Query1[SalesMan]))))))), TRUE(), FALSE())
did not use the measure and took the boolean expression in the if statement
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.
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.