cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Make a pie chart that does not slice it self UNTIL user filters it

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.PieChartProblem.png

 

productexportdomesticdate
A035/15/2020
B1505/15/2020
C2005/15/2020
C0275/16/2020
B3005/16/2020
A0215/16/2020
A0125/17/2020
B1005/17/2020
C0155/17/2020
5 REPLIES 5
Community Support
Community Support

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.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

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

 

ColorProductCustomerweek ofMethodSales PersonDomestic/ExportDay SoledLedgendGreen Products Sold
RedAcust_A10/3/2020Method_ARayDomestic7 - SaturdayMethod_A - A19
RedBcust_B10/3/2020Method_AJoDomestic7 - SaturdayMethod_A - B14
GreenCcust_A10/3/2020Method_AJoDomestic3 - TuesdayMethod_A - C45
RedBcust_B10/3/2020Method_ARayExport6 - FridayMethod_A - B56
RedDcust_A10/3/2020Method_ALouiDomestic3 - TuesdayMethod_A - D2
GreenCcust_C10/3/2020Method_AGillDomestic3 - TuesdayMethod_A - C14
RedEcust_A10/3/2020Method_AShawExport3 - TuesdayMethod_A - E67
GreenFcust_A10/3/2020Method_BJoDomestic7 - SaturdayMethod_B - F0
GreenCcust_A10/3/2020Method_AGillDomestic7 - SaturdayMethod_A - C48
Super User IV
Super User IV

@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/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors