Forum Discussion

DavidB023's avatar
DavidB023
Helper III
8 years ago
Solved

Slicers

Hi everybody !

 

I have a slicer on my repport in order to display a value in euros, the rest to spend in euros and a purcentage of my rest to spend.

So, I have many category but when I diselected each category, I have the total in euros (thanks sum) and the total in purcent (because of sum) like 280% .

In fact, I want to display, when nothing is select, the total purcentage, on 100%, of my total value.

 

Does anybody can help me please ?

 

Thanks

Best regard

David

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi DavidB023

    After modifying the measure2 in my pbix provided as below

    Measure 2 =
IF (
    HASONEVALUE ( Table1[Category] ),
    [Measure],
    SUM ( Table1[Rest to spend] ) / SUM ( Table1[Budget] )
)

    I can show it on the visual when nothing is selected as follows.

     

    Best Regards

    Maggie

6 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago
    How is your formula (“percentage of my rest to spend”) created?
    How is the percentage reflected by selection of categories?
    Could  you share me some data example?
     
     
    Best Regards
    Maggie