Enter a Single Measure value which dynamically changes using sliders as a seperate row in Table!

[Arjun3434]

Hi Everyone,

I am new to Power-BI, I had few requirement any help would be appreciated.

Mnay Thanks!

Requirement 1:

I have these measure which keeps on updating based on slider input seleted by the user as show below:

I want to assigh this value as Product 'XX' and visualize it on bar graph compared to other products:

Graph I am getting:                                                                                   Graph I require:

             

Requirement 2:

Calculate Rank percentage and show it as card value for the same calculated measure as shown above.

For example I have many products ranked on Regional level as shown below in table, I want to compare the rank with calculated column with  "This NPD RoS" add it as seperate product category and get the rank perecentage:

[Arjun3434]

Hi MFelix,

Thanks for taking up this problem, sharing dummy power bi file with dummy data.

If you could somehow solve the problem of graph, I have somehow managed to compute Rank percentage, just  the graph would be of great help.

Just to be sure my measure keeps on changing if there is a slider, over here its static.

Data:

Market	Product	Sales
US	A	12
US	A	30
US	B	24
UK	B	56
UK	C	43
UAE	C	24
UAE	A	76
UAE	B	32

Measure which keep fluctuation as per slider input, add product D as a seperate row and plot a single bar graph.

[Arjun3434]

Product D would be present and added for each Market selected on the filter.

[MFelix]

Hi @Arjun3434 

Has refered create a table with the products and add the additional product in this case we have a table with

Product

A
B
C
D

This is a disconnected table, you can achieve this in DAX or Power Query by picking up all the values and adding the D codes below:

Dax Table = UNION(DISTINCT(Sales[Product]), {"D"})

let
    Source = Table.Distinct( Table.FromList( Sales[Product])),
    Custom1 = Table.InsertRows ( Source, 3, {[Column1 = "D" ]})
in
    Custom1

In my example I did a direct input.

Now you just need to add the following measure:

Product Sales =
SWITCH (
    SELECTEDVALUE ( 'Product and Others'[Product] ),
    "D", [D Product Value],
    CALCULATE (
        SUM ( Sales[Sales] ),
        Sales[Product] IN VALUES ( 'Product and Others'[Product] )
    )
)

For the color do the following measure:

Product Sales Color = SWITCH(SELECTEDVALUE('Product and Others'[Product]), "D", "Orange")

Setup your chart on the following way:

• X-Axis: Product from the new table you created
• Y-Axis: Product Sales measure
• Color: Product Sales Color

Resutl below:

Has you can see I added a what if parameter to simulate your measure but it works in a similar way.

PBIX file attach.

[MFelix · Accepted solution]

Hi @Arjun3434 ,

To achieve this you need to have a table with the junction between your products and this new item.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.