cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Is possible to show One Metric with details and rest simple by using Dax functions ?

Hello,

I need to show measures dynamically in Grid or Matrix visual, I have a set of data with over 20+ Metrics precalculate in SQL.

Those measures come from different Fact tables and it is with tabular data.

Based on from audience request I am looking to see if can be possible to do this: Using Dynamic Slicer show in the front one measure with some extra analisis (frame in blue) then keep showing the rest of the other measures simple as thier value come.

I am be able to change dynamically the blue frame but I wondering if it is possible to show the rest of the measures.

I am looking to do it in DAX but let please know if this can be done under Dax or under Query Editor but my preference is under dax.

 

For example from the slicer metric selection I choose metric A.
This one show all the details related variance, vol, vol% , impact, etc. but then rest of the metrics not select show next the metric selected it.

cluster.1590531736.png

 

Then if Metric B is select show the details and rest of the metrics simple.(metric b is back wit rest of the metrics)

cluster.1590531839.png

If the Metric c is select the that change in the blue frame and now metric B and metric A are back wit the rest of the metrics

Apprecite your advice and guide.

5 REPLIES 5
Highlighted
Solution Specialist
Solution Specialist

Re: Is possible to show One Metric with details and rest simple by using Dax functions ?

You can look at this:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Chart-of-Accounts-Totalling/m-p/1135767#M1692...

 

Put the columns (that are specified in a separate table) in a hierarchy. Put this hierarchy in a slicer to determine what is shown in the display. 

 

Please mark as solution if this is what you are looking for.

 

Kind regards,

 

 

Steve. 

Highlighted
Advocate II
Advocate II

Re: Is possible to show One Metric with details and rest simple by using Dax functions ?

 

thanks but.. mmm not sure if this will work... because I need in the same table not spliting in two tables.

Doing two tables separate will run the risk that one side of the table does not brings value for one agent...it  will not visible in the one of the table at be separate.
What I need to think is to pickup the value from the metric selection and storage in a variable where It will be the one be exclude from the metric list..

 

 

 

Highlighted
Solution Specialist
Solution Specialist

Re: Is possible to show One Metric with details and rest simple by using Dax functions ?

I have difficulty understanding your requirements.

Highlighted
Advocate II
Advocate II

Re: Is possible to show One Metric with details and rest simple by using Dax functions ?

This is about to rotate the list of measures from the table.
One at that time, the measure selected will have more details on the metric itself such as: their Impact, Denominator_Volume %, and variance percentage. Next to those details the rest of the measures will still show at the Right of the table.

Highlighted
Solution Specialist
Solution Specialist

Re: Is possible to show One Metric with details and rest simple by using Dax functions ?

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors