Slicers

[DavidB023]

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

[v-juanli-msft]

Hi @DavidB023

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

[DavidB023]

Hi @v-juanli-msft,

You will find a .pbix like I have for my work. In fact, I consider a line All with formula that is fit in this framework but it appear two line all...

https://1drv.ms/u/s!AlpYVjQtU7WhiS1xfWK_pBilOtGO

Thanks for your time

Best regards

David

[v-juanli-msft]

Hi @DavidB023

I can solve it but create measures instead of calculated columns.

Here is my modified pbix.

Best Regards

Maggie

[DavidB023]

@v-juanli-msft


Do you think it is possible to have when nothing is select, just the purcent of the total rest compared to total budget ?

Thanks

Best regards

David

[v-juanli-msft · Accepted solution]

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

[DavidB023]

@v-juanli-msft

It's perferct ! Thanks

Best regards

David