cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jdusek92
Helper III
Helper III

Text box dynamic value - filtering and DAX

Hello,

I have a question about dynamic values in the text box.

  • Why does it say there is no filter applied when obviously it is not correct?

jdusek92_0-1632956960655.png

 

  • Is it possible to apply a filter to the whole text box/ single dynamic field in the text box?

 

  •  My last question is - is it possible to view the DAX for the measure? How can I check the calculation is correct when I used only the "natural" language to define it?

 

 

Warm regards,

Jakub

1 ACCEPTED SOLUTION

Hi @jdusek92 ,

 

As you type a value name, you can choose from a list of suggestions as you do in a Q&A visual. So, in addition to asking questions of your data in a Q&A visual, you can now create your own calculations with using Data Analysis Expressions (DAX).

vkkfmsft_1-1633406016809.png

 

Note that you can only use simple DAX such as SUM, COUNT, etc. If you want to use a complex DAX, you can reference it in the smart narrative after creating the measure.

 

vkkfmsft_0-1633405845440.png

 

For more information, please refer to:

https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-smart-narrative 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

6 REPLIES 6
jdusek92
Helper III
Helper III

@TheoC  thank you for your effort.

 

Anybody else can help with this one?

Also my other questions:

  • Is it possible to apply a filter to the whole text box/ single dynamic field in the text box?
  •  My last question is - is it possible to view the DAX for the measure? How can I check the calculation is correct when I used only the "natural" language to define it?

Hi @jdusek92 ,

 

As you type a value name, you can choose from a list of suggestions as you do in a Q&A visual. So, in addition to asking questions of your data in a Q&A visual, you can now create your own calculations with using Data Analysis Expressions (DAX).

vkkfmsft_1-1633406016809.png

 

Note that you can only use simple DAX such as SUM, COUNT, etc. If you want to use a complex DAX, you can reference it in the smart narrative after creating the measure.

 

vkkfmsft_0-1633405845440.png

 

For more information, please refer to:

https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-smart-narrative 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

TheoC
Memorable Member
Memorable Member

@jdusek92 from looking at the screenshots, you have a Slicer visual highlighting Age 33 therefore the logic that will follow is:

  • "Age" slicer will filter all ages to that specifically selected.
  • "Age" slicer has Age 33 selected. Therefore, no other data / records will be presented in the output.
  • Max age = 33 which is logically correct.

The way to work around this is to create a measure that ignores filters and the age, irrespective of that selected in the Slicer, will be the max age in the population.

 

Hope this helps 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?  www.linkedin.com/in/theoconias

Hello,

sorry, you misunderstood my question.  Slicer is working correctly, filtering the data only to Age=33.

 

I am asking why is it showing that no filter is applied -the big red box.

When obviously filter IS applied

jdusek92_1-1632961279402.png

 

 

 

 

TheoC
Memorable Member
Memorable Member

@jdusek92 my bad mate! Completely misread on my part. I believe this is to do with one being a Slicer versus one being a Filter (i.e. different in nature in that "on canvas" versus "behind the scenes" approach).  Therefore, if you were to put the filter as a filter, rather than a slicer, it should appear.  Hope this helps 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?  www.linkedin.com/in/theoconias

TheoC
Memorable Member
Memorable Member

@jdusek92 I tried to apply the logic that Power BI supposedly uses and irrespective of the way in which filters / slicers are used, they are not presented. 

 

Example on-canvas with no filters:

TheoC_0-1632962522480.png

Example with filters:

TheoC_1-1632962560225.png

Sorry I couldn't be more help mate. Looks like it's a flaw in the system.

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?  www.linkedin.com/in/theoconias

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors