Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Roy_B
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
v-diye-msft
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
amitchandak
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.